The following are system tables and stored procedures found in the master database and all user databases. This list contains both documented and undocumented system tables and stored procedures.
Tables in every database
dtproperties
syscolumns
syscomments
sysdepends
sysfilegroups
sysfiles
sysfiles1
sysforeignkeys
sysfulltextcatalogs
sysfulltextnotify
sysindexes
sysindexkeys
sysmembers
sysobjects
syspermissions
sysproperties
sysprotects
sysreferences
systypes
sysusers
Stored Procedures in every database
dt_addtosourcecontrol
dt_addtosourcecontrol_u
dt_adduserobject
dt_adduserobject_vcs
dt_checkinobject
dt_checkinobject_u
dt_checkoutobject
dt_checkoutobject_u
dt_displayoaerror
dt_displayoaerror_u
dt_droppropertiesbyid
dt_dropuserobjectbyid
dt_generateansiname
dt_getobjwithprop
dt_getobjwithprop_u
dt_getpropertiesbyid
dt_getpropertiesbyid_u
dt_getpropertiesbyid_vcs
dt_getpropertiesbyid_vcs_u
dt_isundersourcecontrol
dt_isundersourcecontrol_u
dt_removefromsourcecontrol
dt_setpropertybyid
dt_setpropertybyid_u
dt_validateloginparams
dt_validateloginparams_u
dt_vcsenabled
dt_verstamp006
dt_whocheckedout
dt_whocheckedout_u
Tables the master database
dtproperties
MSreplication_options
spt_datatype_info
spt_datatype_info_ext
spt_fallback_db
spt_fallback_dev
spt_fallback_usg
spt_monitor
spt_provider_types
spt_server_info
spt_values
sysaltfiles
syscacheobjects
syscharsets
syscolumns
syscomments
sysconfigures
syscurconfigs
syscursorcolumns
syscursorrefs
syscursors
syscursortables
sysdatabases
sysdepends
sysdevices
sysfilegroups
sysfiles
sysfiles1
sysforeignkeys
sysfulltextcatalogs
sysfulltextnotify
sysindexes
sysindexkeys
syslanguages
syslockinfo
syslocks
sysmembers
sysmessages
sysobjects
sysperfinfo
syspermissions
sysprocesses
sysproperties
sysprotects
sysreferences
SYSREMOTE_CATALOGS
SYSREMOTE_COLUMN_PRIVILEGES
SYSREMOTE_COLUMNS
SYSREMOTE_FOREIGN_KEYS
SYSREMOTE_INDEXES
SYSREMOTE_PRIMARY_KEYS
SYSREMOTE_PROVIDER_TYPES
SYSREMOTE_SCHEMATA
SYSREMOTE_STATISTICS
SYSREMOTE_TABLE_PRIVILEGES
SYSREMOTE_TABLES
SYSREMOTE_VIEWS
sysservers
systypes
sysusers
sysxlogins
Stored Procedures in the master database
Note: This article lists over 1000 system stored procedures. Due to the length, we’re not showing the complete list here. Please refer to SQL Server documentation for a comprehensive list of system stored procedures.
The system stored procedures include functions for:
- Database administration
- Security management
- Replication
- Full-text search
- Data validation
- Performance monitoring
- Job scheduling
- And many other SQL Server functions
Beekeeper Studio Is A Free & Open Source Database GUI
Best SQL query & editor tool I have ever used. It provides everything I need to manage my database. - ⭐⭐⭐⭐⭐ Mit
Beekeeper Studio is fast, intuitive, and easy to use. Beekeeper supports loads of databases, and works great on Windows, Mac and Linux.
What Users Say About Beekeeper Studio
"Beekeeper Studio completely replaced my old SQL workflow. It's fast, intuitive, and makes database work enjoyable again."
"I've tried many database GUIs, but Beekeeper strikes the perfect balance between features and simplicity. It just works."