Adaptive Server and SAP Sybase IQ have different system catalogs, reflecting the different uses for the two products.
In Adaptive Server, there is a single master database containing a set of system tables holding information that applies to all databases on the server. Many databases may exist within the master database, and each has additional system tables associated with it.
In SAP Sybase IQ, each database exists independently, and contains its own system tables. There is no master database that contains system information on a collection of databases. Each server may run several databases at a time, dynamically loading and unloading each database as needed.
The Adaptive Server and SAP Sybase IQ system catalogs are different. The Adaptive Server system tables and views are owned by the special user dbo, and exist partly in the master database, partly in the sybsecurity database, and partly in each individual database; the SAP Sybase IQ system tables and views are owned by the special user SYS and exist separately in each database.
To assist in preparing compatible applications, SAP Sybase IQ provides a set of views owned by the special user dbo, which correspond to the Adaptive Server system tables and views. Where architectural differences make the contents of a particular Adaptive Server table or view meaningless in a SAP Sybase IQ context, the view is empty, containing only the column names and data types.
These topics list the Adaptive Server system tables and their implementation in the SAP Sybase IQ system catalog. The owner of all tables is dbo in each DBMS.