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 the 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. |
|
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. |
|
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. |