The following system tables occur in all databases:
System table |
Contents |
|---|---|
One row for each Adaptive Server user mapped to a database user |
|
One row for each object attribute definition |
|
One row for each column in a table or view, and for each parameter in a procedure |
|
One or more rows for each view, rule, default, trigger, and procedure, giving SQL definition statement |
|
One row for each referential and check constraint associated with a table or column |
|
One row for each procedure, view, or table that is referenced by a procedure, view, or trigger |
|
Allocation bitmaps for an entire database |
|
One row for each clustered or nonclustered index, one row for each table with no indexes, and an additional row for each table containing text or image data |
|
One row for each Java archive (JAR) file that is retained in the database. Uses row-level locking |
|
One row for each primary, foreign, or common key; set by user (not maintained by Adaptive Server) |
|
Transaction log |
|
One row for each table, view, procedure, rule, trigger default, log, and (in tempdb only) temporary object |
|
One row for each partition (page chain) of a partitioned table |
|
One row for each view, rule, default, trigger, and procedure, giving internal definition |
|
User permissions information |
|
Abstract query plans and SQL text |
|
One row for each referential integrity constraint declared on a table or column |
|
Maps server-wide roles to local database groups |
|
One row for each segment (named collection of disk pieces) |
|
One or more rows for each indexed column on a user table. May also contain rows for unindexed column |
|
One row for each table, plus one row for each nonclustered index |
|
One row for each threshold defined for the database |
|
One row for each system-supplied and user-defined datatype |
|
One row for each user-defined message |
|
One row for each user allowed in the database |
|
One row for each extended, Java-SQL datatype. Uses row-level locking |
