This section provides very brief descriptions for Adaptive Server system tables. See Reference Manual: Tables for more a full description.
master database only – contains one row for each update of the maximum number of licenses used in Adaptive Server per 24-hour period.
All databases – contains one row for each Adaptive Server user that is mapped or aliased to a user of the current database.
All databases – defines 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 – These system tables 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, partition, procedure, computed column, function-based index key, and other forms of compiled objects.
master database only – contains one row for each configuration parameter that can be set by the user.
All databases – Whenever a user declares a new check constraint or referential constraint using create table or alter table, Adaptive Server inserts a row into the sysconstraints table.
sybsystemdb database only – contains information about remote Adaptive Servers participating in distributed transactions (remote participants) and their coordination states.
master database only – 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. In addition, it contains four rows that describe the configuration structure.
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.
Reserved for future use.
master database only – contains one row for each Adaptive Server engine currently online.
All databases – stores the global allocation map (GAM) for the database.
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.This table also contains one row for each function-based index or index created on a computed column.
All databases – contains one row for each Java archive (JAR) file that is retained in the database.
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, and 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. Adaptive Server displays the error description on the user’s screen.
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, computed column, function-based index key, and (in tempdb only) temporary object, and other forms of compiled objects. It also contains one row for each partition condition ID when object type is N.
All databases – contains one row for each partition key for hash, range, and list partitioning of a table. All columns are not null.
All databases – contains one row for each data partition and one row for each index partition.
All databases – contains entries for each view, default, rule, trigger, procedure, declarative default, partition condition, check constraint, comuted column, function-based index key, and other forms of compiled objects.
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. No updates to sysprocesses are allowed. Use the kill statement to kill a process.
All databases – contains information on permissions that have been granted to, or revoked from, users, groups, and roles.
All databases – presents aggregated historical query processing metrics for individual queries from persistent data. In addition to monitoring tables, use performance metrics information from this catalog.
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. syssecmechs is not created during installation, rather, it is built dynamically when queried by a user.
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 used only when Adaptive Server is configured for Sybase Failover in a high availability system. syssessions contains one row for each client that connects to Adaptive Server with the failover property.
All databases – contains one row for each slice (page chain) of a sliced table. sysslices is used only during the Adaptive Server upgrade process. After the upgrade is complete, all the data is removed.
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 and for each partition. May also contain rows for unindexed column.
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 partition.
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. Portions of the table are built dynamically when queried by a user, while other portions are stored in the master database. Updates to the dynamically-built columns of systransactions are not allowed.
All databases – contains one row for each system-supplied and user-defined datatype. Domains (defined by rules) and defaults are given, if they exist.
master database only – sysusages contains one row for each disk allocation piece assigned to a database. Each database contains a specified number of database (logical) page numbers.
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.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
