| System Table | Purpose | Description |
|---|
| Backupfile | Msdb | Lists all files that are backed up |
| Backupmediafamily | Msdb | Lists information about media families used for backups |
| Backupmediaset | Msdb | Lists information about media sets used for backups |
| Backupset | Msdb | Lists all backup sets for the server |
| MSagent_parameters | Distribution | Stores parameters used for replication agents on the server |
| MSagent_profiles | Distribution | Stores profile information for replication agents on the server |
| Msarticles | Distribution | Stores information about articles that are replicated on the server |
| Msdistpublishers | Distribution | Stores information about remote publishers on the server |
| MSdistribution_agents | Distribution | Stores information about distribution agents |
| MSdistribution_history | Distribution | Stores historical information about distribution agents |
| Msdistributiondbs | Distribution | Contains database information for each server configured as a distributor |
| Msdistributor | Distribution | Stores distribution properties |
| MSlogreader_agents | Distribution | Stores log reader agent information |
| MSlogreader_history | Distribution | Stores historical data about log reader agents |
| MSmerge_agents | Distribution | Stores configuration information about merge agents for a distributor |
| MSmerge_contents | User | Contains changes to a publication in a database |
| MSmerge_delete_conflicts | User | Lists deleted rows for subscriptions in a database that were removed due to conflicts |
| MSmerge_genhistory | User | Contains history of generated subscriptions in a database |
| MSmerge_history | Distribution | Contains historical merge information for a distributor |
| MSmerge_replinfo | User | Contains information about replication information that has been sent to or received from a subscription article |
| MSmerge_subscriptions | Distribution | Contains subscription information used by a distributor |
| MSmerge_tombstone | User | Lists deleted rows for subscriptions in a database |
| MSpublication_access | Distribution | Stores publications that each SQL Server login has access to |
| Mspublications | Distribution | Stores information about each publication that a distributor is responsible for |
| Mspublisher_databases | Distribution | Stores information about which databases a distributor is responsible for |
| MSrepl_commands | Distribution | Stores information about commands that are replicated |
| MSrepl_errors | Distribution | Stores information about errors generated during replication |
| Msrepl_originators | Distribution | Stores information relating to subscriber and originator |
| MSrepl_transactions | Distribution | Stores information replicated transactions |
| MSrepl_version | Distribution | Stores information about the version of replication used for a distributor |
| MSreplication_objects | Distribution | Stores information about each object that is to be replicated by a distributor |
| MSreplication_subscriptions | Distribution | Stores replication information about each subscription |
| MSsnapshot_agents | Distribution | Stores information about each snapshot agent that the distributor is responsible for |
| MSsnapshot_history | Distribution | Contains historical information about snapshot replication |
| MSsubscriber_info | Distribution | Contains information about subscribers that a distributor is responsible for |
| MSsubscriber_schedule | Distribution | Contains information about the schedules of subscribers that a distributor is responsible for |
| Mssubscription_properties | Distribution | Contains information about the properties of subscriptions that a distributor is responsible for |
| Mssubscriptions | Distribution | Contains information about subscriptions that a distributor is responsible for |
| Restorefile | Msdb | Lists all files that are restored for the server |
| Restorefilegroup | Msdb | Lists all file groups that are restored for the server |
| Restorehistory | Msdb | Lists information about all prior restorations of data for the server |
| Sysalerts | Msdb | Stores job alert information for SQL Server |
| Sysallocations | User | Stores allocation units in a database |
| Sysaltfiles | Master | Lists location of database files and properties of those files, such as growth allowances for the server |
| Sysarticles | Master | Stores all defined replication articles in all databases |
| Sysarticleupdates | User | Stores all articles in a database that can immediately update any subscriber for the article |
| Syscacheobjects | Master | Stores information about the usage of the system cache for the server |
| Syscategories | Msdb | Stores categories of job-related information, such as jobs, alerts, and operators |
| Syscharsets | Master | Stores all character sets that are installed on SQL Server |
| Syscolumns | User | Stores all of the columns and views for all tables of a database |
| Syscomments | User | Stores the text that makes up stored procedures, views, rules, defaults, and triggers. However, this text will not be readable if it isencrypted. |
| Sysconfigures | Master | Stores all of the configuration options for the server |
| Sysconstraints | User | Stores information about all of the constraints in a database |
| Syscurconfigs | Master | Stores the current configuration options for the server |
| Sysdatabases | Master | Lists all of the databases and their properties for the server |
| Sysdepends | User | Lists all dependency information objects which depend on other objects) for all objects in a database. |
| Sysdevices | Master | Stores location of backup devices for the server |
| Sysdownloadlist | Msdb | Stores all download instructions for all target servers |
| Sysfilegroups | User | Stores information about the filegroups created in a database |
| Sysfiles | User | Virtual table, or view, that stores information about database files |
| Sysforeignkeys | User | Stores all foreign key constraints in a database |
| Sysfulltextcatalogs | User | Stores full-text searching catalogs in a database |
| Sysindexes | User | Stores all indexing information for all indexes in a database |
| Sysindexkeys | User | Stores the key fields that are contained in an index |
| Sysjobhistory | Msdb | Stores job history and status for prior jobs in SQL Server |
| Sysjobs | Msdb | Stores job information for SQL Server |
| Sysjobschedules | Msdb | Stores job scheduling information for SQL Server |
| Sysjobservers | Msdb | Stores the relationship of servers that are used in job processing |
| Sysjobsteps | Msdb | Stores the steps of each job for SQL Server |
| Syslanguages | Master | Stores all languages that are installed on SQL Server |
| Syslockinfo | Master | Stores information about current SQL Server locks for the server |
| Syslogins | Master | Stores all logins that are allowed to log into SQL Server in a virtual table, or a view |
| Sysmembers | User | Stores all users who are members of roles within a database |
| Sysmergearticles | User | Stores all merge articles in a database |
| Sysmergepublications | User | Stores all merge publications in a database |
| Sysmergeschemachange | User | Stores information about snapshot articles in a database |
| Sysmergesubscriptions | User | Stores information about subscribers of articles in a database |
| Sysmergesubsetfilters | User | Stores information about partitioned articles |
| Sysmessages | Master | Lists all error and warning messages |
| Sysnotifications | Msdb | Stores job notification information for the server |
| Sysobjects | User | Stores all objects in a database, such as stored procedures, views, and triggers |
| Sysoledbusers | Master | Stores user name and password for each linked SQL Server |
| Sysoperators | Msdb | Stores information about job operators for the server |
| Sysperfinfo | Master | Stores information about SQL Server’s performance counters |
| Syspermissions | User | Stores permissions for users, groups, and roles in a database |
| Sysprocesses | Master | Lists data about the currently running processes in SQL Server |
| Sysprotects | User | Stores permissions for objects in a database |
| Syspublications | Master | Stores all defined replication publications in all databases |
| Sysreferences | User | Stores foreign key mappings for each foreign key defined in a database |
| Sysremotelogins | Master | Stores information about logins that are allowed to run remote stored procedures for the server |
| Sysreplicationalerts | Master | Stores all defined replication alert conditions in all databases |
| Sysservers | Master | Stores all servers that can be accessed by using OLE DB. |
| Syssubscriptions | Master | Stores all defined replication publication in all databases |
| Systargetservergroupmembers | Msdb | Stores information about which servers are members of server groups |
| Systargetservergroups | Msdb | Stores information about groups of servers that are used within jobs |
| Systargetservers | Msdb | Stores information about servers that are used within jobs |
| Systaskids | Msdb | Stores information about tasks used in prior versions of SQL Server |
| Systypes | User | Stores user-defined type information as defined within a database |
| Sysusers | User | Stores information about users or roles of a database |
