The following system tables occur only in the master database:
System table |
Contents |
---|---|
One row for each character set or sort order |
|
One row for each configuration parameter that can be set by users |
|
Information about configuration parameters currently being used by Adaptive Server |
|
One row for each database on Adaptive Server |
|
One row for each tape dump device, disk dump device, disk for databases, and disk partition for databases |
|
One row for each Adaptive Server engine currently online |
|
One row for each language (except U.S. English) known to the server |
|
One row for each type of network connection used by current Adaptive Server |
|
Information about active locks |
|
One row for each server login that possesses a system role |
|
One row for each valid Adaptive Server user account |
|
Information about the oldest active transaction and the Replication Server® truncation point for each database |
|
One row for each system error or warning |
|
One row for each monitor counter |
|
Information about server processes |
|
One row for each remote user |
|
One row for each resource limit |
|
Information about the security services available for each security mechanism that is available to Adaptive Server |
|
One row for each remote Adaptive Server |
|
Only used when Adaptive Server is configured for Sybase’s Failover in a high availability system. syssessions contains one row for each client that connects to Adaptive Server with the failover property (for example, isql -Q) |
|
One row for each server-wide role |
|
One row for each named time range |
|
One row for each transaction |
|
One row for each disk piece allocated to a database |