SQL Server System table system view and role description

The SQL Server System view can be divided into:

• catalog view Compatibility View dynamic management view and function Information Schema View Copy view

system table:Sysaltfiles the primary database to save the database file

Syscharsets primary database character set and sort order

Sysconfigures Primary Database configuration options

Syscurconfigs Primary Database Current configuration options

sysdatabases databases in the primary database server

Syslanguages Primary Database language

syslogins Main Database login account information

Sysoledbusers Primary Database link Server login information

sysprocesses master database process

Sysremotelogins master database telnet account

syscolumns each database column

Sysconstrains per database limit

Sysfilegroups per database filegroup

Sysfiles per database file

Sysforeignkeys each database external keyword

Sysindexs per database index

Sysmenbers each database role member

Sysobjects all database objects per database

Syspermissions per database permissions

Systypes per database user-defined data type

sysusers per database user

catalog view:

Sys.allocation_units	Sys.parameters
Sys.assembly_modules	Sys.partitions
Sys.check_constraints	Sys.procedures
Sys.columns	Sys.service_queues
Sys.computed_columns	Sys.spatial_index_tessellations
Sys.default_constraints	Sys.spatial_indexes
Sys.events	Sys.sql_dependencies
Sys.event_notifications	Sys.sql_expression_dependencies
Sys.extended_procedures	Sys.sql_modules
Sys.foreign_key_columns	Sys.stats
Sys.foreign_keys	Sys.stats_columns
Sys.function_order_columns	Sys.synonyms
Sys.identity_columns	Sys.table_types
Sys.index_columns	Sys.tables
Sys.indexes	Sys.trigger_event_types
Sys.key_constraints	Sys.trigger_events
Sys.numbered_procedure_parameters	Sys.triggers
Sys.numbered_procedures	Sys.views
Sys.objects

SQL Server System table system view and role description