List Of System Tables In SQL Server

List Of System Tables In SQL Server

System Tables in the master Database Only

1. sysaltfiles
2. syslockinfo
3. syscacheobjects
4. syslogins
5. syscharsets
6. sysmessages
7. sysconfigures
8. sysoledbusers
9. syscurconfigs
10. sysperfinfo
11. sysdatabases
12. sysprocesses
13. sysdevices
14. sysremotelogins
15. syslanguages
16. sysservers

System Tables in Every Database

1. syscolumns
2. sysindexkeys
3. syscomments
4. sysmembers
5. sysconstraints
6. sysobjects
7. sysdepends
8. syspermissions
9. sysfilegroups
10. sysprotects
11. sysfiles
12. sysreferences
13. sysforeignkeys
14. systypes
15. sysfulltextcatalogs
16. sysusers
17. sysindexes

SQL Server Agent Tables in the msdb Database

1. sysalerts
2. sysjobsteps
3. syscategories
4. sysnotifications
5. sysdownloadlist
6. sysoperators
7. sysjobhistory
8. systargetservergroupmembers
9. sysjobs
10. systargetservergroups
11. sysjobschedules
12. systargetservers
13. sysjobservers
14. systaskids

Tables in the msdb Database

1. backupfile
2. restorefile
3. backupmediafamily
4. restorefilegroup
5. backupmediaset
6. restorehistory
7. backupset

Tables Used to Store Replication Information
These tables are used by replication and stored in the master database.

1. sysdatabases
2. sysservers
   

These tables are used by replication and stored in the msdb database.

1. sysreplicationalerts

These tables are used by replication and stored in the distribution database.

1. MSagent_parameters
2. Mspublisher_databases
3. MSagent_profiles
4. MSreplication_objects
5. MSarticles
6. MSreplication_subscriptions
7. MSdistpublishers
8. MSrepl_commands
9. MSdistributiondbs
10. MSrepl_errors
11. MSdistribution_agents
12. MSrepl_originators
13. MSdistribution_history
14. MSrepl_transactions
15. MSdistributor
16. MSrepl_version
17. MSlogreader_agents
18. MSsnapshot_agents
19. MSlogreader_history
20. MSsnapshot_history
21. MSmerge_agents
22. MSsubscriber_info
23. MSmerge_history
24. MSsubscriber_schedule
25. MSmerge_subscriptions
26. MSsubscriptions
27. MSpublication_access
28. MSsubscription_properties
29. Mspublications

These tables are used by replication and stored in the publication database.

1. MSmerge_contents
2. sysmergearticles
3. MSmerge_delete_conflicts
4. sysmergepublications
5. MSmerge_genhistory
6. sysmergeschemachange
7. MSmerge_replinfo
8. sysmergesubscriptions
9. MSmerge_tombstone
10. sysmergesubsetfilters
11. sysarticles
12. syspublications
13. sysarticleupdates
14. syssubscriptions