System tables in master

The following system tables occur only in the master database:

System table

Contents

syscharsets

One row for each character set or sort order.

sysconfigures

One row for each configuration parameter that can be set by users.

syscurconfigs

Information about configuration parameters currently being used by Adaptive Server.

sysdatabases

One row for each database on Adaptive Server.

sysdevices

One row for each tape dump device, disk dump device, disk for databases, and disk partition for databases.

sysengines

One row for each Adaptive Server engine currently online.

syslanguages

One row for each language (except U.S. English) known to the server.

syslisteners

One row for each type of network connection used by the current Adaptive Server.

syslocks

Information about active locks.

sysloginroles

One row for each server login that possesses a system role.

syslogins

One row for each valid Adaptive Server user account.

syslogshold

Information about the oldest active transaction and the Replication Server® truncation point for each database.

sysmessages

One row for each system error or warning.

sysmonitors

One row for each monitor counter.

sysprocesses

Information about server processes .

sysremotelogins

One row for each remote user .

sysresourcelimits

One row for each resource limit.

syssecmechs

Information about the security services available for each security mechanism that is available to Adaptive Server.

sysservers

One row for each remote Adaptive Server.

syssessions

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.

syssrvroles

One row for each server-wide role.

systimeranges

One row for each named time range.

systransactions

One row for each transaction.

sysusages

One row for each disk piece allocated to a database.