Mapping System Tables to System Views (Transact-SQL)
Applies to: SQL Server
This topic shows the mapping between the system tables and functions and system views and functions.
The following table maps the system tables to their corresponding system views or functions in SQL Server.
System table | System views or functions | Type of view or function |
---|---|---|
sysaltfiles | sys.master_files | Catalog view |
syscacheobjects | sys.dm_exec_cached_plans sys.dm_exec_plan_attributes (Transact-SQL) sys.dm_exec_sql_text sys.dm_exec_cached_plan_dependent_objects |
Dynamic management view Dynamic management view Dynamic management view Dynamic management view |
syscharsets | sys.syscharsets | Compatibility view |
sysconfigures | sys.configurations | Catalog view |
syscurconfigs | sys.configurations | Catalog view |
sysdatabases | sys.databases | Catalog view |
sysdevices | sys.backup_devices | Catalog view |
syslanguages | sys.syslanguages | Compatibility view |
syslockinfo | sys.dm_tran_locks | Dynamic management view |
syslocks | sys.dm_tran_locks | Dynamic management view |
syslogins | sys.server_principals sys.sql_logins |
Catalog view |
sysmessages | sys.messages | Catalog view |
sysoledbusers | sys.linked_logins | Catalog view |
sysopentapes | sys.dm_io_backup_tapes | Dynamic management view |
sysperfinfo | sys.dm_os_performance_counters | Dynamic management view |
sysprocesses | sys.dm_exec_connections sys.dm_exec_sessions sys.dm_exec_requests |
Dynamic management view Dynamic management view Dynamic management view |
sysremotelogins | sys.remote_logins | Catalog view |
sysservers | sys.servers | Catalog view |
The following table maps the system tables or functions that are in every database in SQL Server 2000 (8.x) to their corresponding system views or functions in SQL Server 2005 (9.x) and later.
System table or function | System view or function | Type of view or function |
---|---|---|
fn_virtualfilestats | sys.dm_io_virtual_file_stats | Dynamic management view |
syscolumns | sys.columns | Catalog view |
syscomments | sys.sql_modules | Catalog view |
sysconstraints | sys.check_constraints sys.default_constraints sys.key_constraints sys.foreign_keys |
Catalog view Catalog view Catalog view Catalog view |
sysdepends | sys.sql_expression_dependencies | Catalog view |
sysfilegroups | sys.filegroups | Catalog view |
sysfiles | sys.database_files | Catalog view |
sysforeignkeys | sys.foreign_key_columns | Catalog view |
sysindexes | sys.indexes sys.partitions sys.allocation_units sys.dm_db_partition_stats |
Catalog view Catalog view Catalog view Dynamic management view |
sysindexkeys | sys.index_columns | Catalog view |
sysmembers | sys.database_role_members | Catalog view |
sysobjects | sys.objects | Catalog view |
syspermissions | sys.database_permissions sys.server_permissions |
Catalog view Catalog view |
sysprotects | sys.database_permissions sys.server_permissions |
Catalog view Catalog view |
sysreferences | sys.foreign_keys | Catalog view |
systypes | sys.types | Catalog view |
sysusers | sys.database_principals | Catalog view |
sysfulltextcatalogs | sys.fulltext_catalogs | Catalog view |
See Also
Catalog Views (Transact-SQL)
Dynamic Management Views and Functions (Transact-SQL)
System Tables (Transact-SQL)
Váš názor
https://aka.ms/ContentUserFeedback.
Připravujeme: V průběhu roku 2024 budeme postupně vyřazovat problémy z GitHub coby mechanismus zpětné vazby pro obsah a nahrazovat ho novým systémem zpětné vazby. Další informace naleznete v tématu:Odeslat a zobrazit názory pro