Wednesday, September 16, 2009

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 




Tags: sql server system tables. system table. master db tables. sql master tables. sql system tables list. system tables list. sql server system table list. list of system tables. list of master tables. list of master db tables. List All the Tables for All Databases Using System tables. SQL Server Important System Views and Tables. SQL Server 2005 System Tables and Views. SQL Server 2012 System Tables and Views. SQL Server 2008 System Tables and Views. Inside SQL Server: System Tables. How do I get a list of SQL Server tables and their row counts. system tables in sql server 2005. system tables in sql server 2000. system tables in sql server 2008 system databases in sql server. list of system tables in sql server. system procedures in sql server. user tables in sql server. oracle system tables.

0 comments:

Post a Comment