See Reference Manual: Tables for details.
All databases – contains one row for each Adaptive Server user mapped (or aliased) to a user of the current database.
All databases – system attributes define properties of objects such as databases, tables, indexes, users, logins, and procedures.
sybsecurity database – contains one row for each server-wide audit option and indicates the current setting for that option.
sybsecurity database – contain the audit trail.
master database only – contains one row for each character set and sort order defined for use by Adaptive Server.
All databases – contains one row for every column in every table and view, and a row for each parameter in a procedure.
All databases – contains entries for each view, rule, default, trigger, table constraint, and procedure.
master database only – contains one row for each configuration parameter that can be set by the user.
All databases – has one row for each referential constraint and check constraint associated with a table or column.
sybsystemdb database only – contains information about remote Adaptive Servers participating in distributed transactions (remote participants) and their coordination states.
master database only – syscurconfigs is built dynamically when queried. It contains an entry for each of the configuration parameters, as does sysconfigures, but with the current values rather than the default values.
master database only – contains one row for each database in Adaptive Server.
All databases – contains one row for each procedure, view, or table that is referenced by a procedure, view, or trigger.
master database only – contains one row for each tape dump device, disk dump device, disk for databases, and disk partition for databases.
master database only – contains one row for each Adaptive Server engine currently online.
All databases – stores the global allocation map (GAM) for the database. The GAM stores a bitmap for all allocation units of a database, with one bit per allocation unit. You cannot select from or view sysgams.
All databases – contains one row for each clustered index, one row for each nonclustered index, one row for each table that has no clustered index, and one row for each table that contains text or image columns.
All databases – contains one row for each Java archive (JAR) file that is retained in the database. Uses row-level locking.
All databases – contains one row for each primary, foreign, or common key.
master database only – contains one row for each language known to Adaptive Server. us_english is not in syslanguages, but it is always available to Adaptive Server.
master database only – contains a row for each network protocol available for connecting with the current Adaptive Server. Adaptive Server builds syslisteners dynamically when a user or client application queries the table.
master database only – contains information about active locks. It is built dynamically when queried by a user. No updates to syslocks are allowed.
master database only – contains a row for each instance of a server login possessing a system role.
master database only – contains one row for each valid Adaptive Server user account.
All databases – contains the transaction log. It is used by Adaptive Server for recovery and roll forward. It is not useful to users.
master database only – contains information about each database’s oldest active transaction (if any) and the Replication Server truncation point (if any) for the transaction log, but it is not a normal table. Rather, it is built dynamically when queried by a user. No updates to syslogshold are allowed.
master database only – contains one row for each system error or warning that can be returned by Adaptive Server.
master database only – contains one row for each monitor counter.
All databases – contains one row for each table, view, stored procedure, extended stored procedure, log, rule, default, trigger, check constraint, referential constraint, and (in tempdb only) temporary object.
All databases – contains one row for each partition (page chain) of a partitioned table.
All databases – contains entries for each view, default, rule, trigger, procedure, declarative default, and check constraint.
master database only – contains information about Adaptive Server processes, but it is not a normal table. It is built dynamically when queried by a user.
All databases – contains information on permissions that have been granted to, or revoked from, users, groups, and roles.
All databases – contains two or more rows for each abstract query plan. Uses datarow locking.
All databases – contains one row for each referential integrity constraint declared on a table or column.
master database only – contains one row for each remote user that is allowed to execute remote procedure calls on this Adaptive Server.
master database only – contains a row for each resource limit defined by Adaptive Server.
All databases – maps server role IDs to local role IDs.
master database only – contains information about the security services supported by each security mechanism that is available to Adaptive Server.
All databases – contains one row for each segment (named collection of disk pieces).
master database only – contains one row for each remote Adaptive Server, Backup Server™, or Open Server™ on which this Adaptive Server can execute remote procedure calls.
master database only – is only used when Adaptive Server is configured for Sybase’s Failover in a high availability system.
master database only – contains a row for each system or user-defined role.
All databases – contains one or more rows for each indexed column on a user table.
All databases – contains one row for each clustered index, one row for each nonclustered index, and one row for each table that has no clustered index.
All databases – contains one row for each threshold defined for the database.
master database only – stores named time ranges, which are used by Adaptive Server to control when a resource limit is active.
master database only – contains information about Adaptive Server transactions, but it is not a normal table.
All databases – contains one row for each system-supplied and user-defined datatype.
master database only – contains one row for each disk allocation piece assigned to a database.
All databases – contains one row for each user-defined message that can be returned by Adaptive Server.
All databases – contains one row for each user allowed in the database, and one row for each group or role.
All databases – contains one row for each extended, Java-SQL datatype. Uses row-level locking.
master database only – contains one row for each update of the maximum number of licenses used in Adaptive Server per 24-hour period.
