Chapter 1: System Tables

System tables in all databases

The following system tables occur in all databases:

System table	Contents
sysalternates	One row for each Adaptive Server user mapped to a database user.
sysattributes	One row for each object attribute definition.
syscolumns	One row for each column in a table or view, and for each parameter in a procedure.
syscomments	One or more rows for each view, rule, default, trigger, and procedure, giving SQL definition statement.
sysconstraints	One row for each referential and check constraint associated with a table or column.
sysdepends	One row for each procedure, view, or table that is referenced by a procedure, view, or trigger.
sysgams	Allocation bitmaps for an entire database.
sysindexes	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.
sysjars	One row for each Java archive (JAR) file that is retained in the database.
syskeys	One row for each primary, foreign, or common key; set by user (not maintained by Adaptive Server).
syslogs	Transaction log.
sysobjects	One row for each table, view, procedure, rule, trigger default, log, and (in tempdb only) temporary object.
syspartitionkeys	One row for each partition key.
syspartitions	One row for each partition of a partitioned table or index.
sysprocedures	One row for each view, rule, default, trigger, and procedure, giving internal definition.
sysprotects	User permissions information.
sysquerymetrics	Gathers aggregated historical query information in a persistent catalog. sysquerymetrics is a view, not a table.
sysqueryplans	Abstract query plans and SQL text.
sysreferences	One row for each referential integrity constraint declared on a table or column.
sysroles	Maps server-wide roles to local database groups.
syssegments	One row for each segment (named collection of disk pieces).
sysslices	Obsolete, used only during upgrade. Formerly called syspartitions before Adaptive Server version 15.0.
sysstatistics	One or more rows for each indexed column on a user table. May also contain rows for unindexed column.
systabstats	One row for each table, plus one row for each nonclustered index.
systhresholds	One row for each threshold defined for the database.
systypes	One row for each system-supplied and user-defined datatype.
sysusermessages	One row for each user-defined message.
sysusers	One row for each user allowed in the database.
sysxtypes	One row for each extended, Java-SQL datatype. Uses row-level locking.

View this book as PDF