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