System Tables–System Catalog

These system tables are found only within the master database:

Table Description
syscharsets Contains one row for each character set and sort order defined for use by SQL Server.
sysconfigures Contains one row for each user-settable configuration option.
syscurconfigs Contains an entry for each of the configuration options, as in sysconfigures, but contains the current values and four entries that describe the configuration structure.
sysdatabases Contains one row for each database on SQL Server.
sysdevices Contains one row for each disk dump device, diskette dump device, tape dump device, and database device.
syslanguages Contains one row for each language known to SQL Server. Although U.S. English is omitted, it is always available to SQL Server.
syslocks Contains information about active locks.
syslogins Contains one row for each valid SQL Server user account.
sysmessages Contains one row for each system error or warning that can be returned by SQL Server.
sysprocesses Contains information about SQL Server processes.
sysremotelogins Contains one row for each remote user who is allowed to call remote stored procedures on this SQL Server.
sysservers Contains one row for each remote SQL Server on which this SQL Server can call remote stored procedures.
sysusages Contains one row for each disk-allocation piece assigned to a database.