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

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)

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