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