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. Uses row-level locking

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

syspartitions

One row for each partition (page chain) of a partitioned table

sysprocedures

One row for each view, rule, default, trigger, and procedure, giving internal definition

sysprotects

User permissions information

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)

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