Chapter 16 System Views
1077
Views for Transact-SQL Compatibility
Adaptive Server Enterprise and Adaptive Server Anywhere have different
system catalogs, reflecting the different uses for the two products.
In Adaptive Server Enterprise, a single master database contains a set of
system tables, which 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 Adaptive Server Anywhere, 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 Enterprise and Adaptive Server Anywhere system
catalogs are different. The Adaptive Server Enterprise 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 Adaptive Server Anywhere system tables and views are owned
by the special user SYS and exist separately in each database.
To assist in preparing compatible applications, Adaptive Server Anywhere
provides a set of views owned by the special user dbo, which correspond to
the Adaptive Server Enterprise system tables and views. Where architectural
differences make the contents of a particular Adaptive Server Enterprise
table or view meaningless in a Adaptive Server Anywhere context, the view
is empty, containing just the column names and data types.
The following tables list the Adaptive Server Enterprise system tables and
their implementation in the Adaptive Server Anywhere system catalog. The
owner of all tables is dbo in each DBMS.
Table name Description Data?
sysalternates One row for each user mapped to a database user No
syscolumns One row for each column in a table or view, and
for each parameter in a procedure
Yes
syscomments One or more rows for each view, rule, default,
trigger, and procedure, giving the SQL definition
statement
Yes
sysconstraints One row for each referential or check constraint
associated with a table or column
No
sysdepends One row for each procedure, view, or table that
is referenced by a procedure, view, or trigger
No
Tables existing in
each Adaptive
Server Enterprise
database
To Next Page
Loading...