Certain system tables occur in all databases.
sysalternates – one row for each SAP ASE 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.
sysencryptkeys – one row for each key created in a database, including the default key.
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 the SAP ASE 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 SAP ASE 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.