Mapping System Tables to System Views (Transact-SQL)
EN
Ta vsebina ni na voljo v vašem jeziku, vendar pa je tukaj angleška različica.

Mapping System Tables to System Views (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 2016.

System tableSystem views or functionsType of view or function
sysaltfilessys.master_filesCatalog view
syscacheobjectssys.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
syscharsetssys.syscharsetsCompatibility view
sysconfiguressys.configurationsCatalog view
syscurconfigssys.configurationsCatalog view
sysdatabasessys.databasesCatalog view
sysdevicessys.backup_devicesCatalog view
syslanguagessys.syslanguagesCompatibility view
syslockinfosys.dm_tran_locksDynamic management view
syslockssys.dm_tran_locksDynamic management view
sysloginssys.server_principals

 sys.sql_logins
Catalog view
sysmessagessys.messagesCatalog view
sysoledbuserssys.linked_loginsCatalog view
sysopentapessys.dm_io_backup_tapesDynamic management view
sysperfinfosys.dm_os_performance_countersDynamic management view
sysprocessessys.dm_exec_connections

 sys.dm_exec_sessions

 sys.dm_exec_requests
Dynamic management view

Dynamic management view

Dynamic management view
sysremoteloginssys.remote_loginsCatalog view
sysserverssys.serversCatalog view

The following table maps the system tables or functions that are in every database in SQL Server 2000 to their corresponding system views or functions in SQL Server 2016.

System table or functionSystem view or functionType of view or function
fn_virtualfilestatssys.dm_io_virtual_file_statsDynamic management view
syscolumnssys.columnsCatalog view
syscommentssys.sql_modulesCatalog view
sysconstraintssys.check_constraints

 sys.default_constraints

 sys.key_constraints

 sys.foreign_keys
Catalog view

Catalog view

Catalog view

Catalog view
sysdependssys.sql_expression_dependenciesCatalog view
sysfilegroupssys.filegroupsCatalog view
sysfilessys.database_filesCatalog view
sysforeignkeyssys.foreign_key_columnsCatalog view
sysindexessys.indexes

 sys.partitions

 sys.allocation_units

 sys.dm_db_partition_stats
Catalog view

Catalog view

Catalog view

Dynamic management view
sysindexkeyssys.index_columnsCatalog view
sysmemberssys.database_role_membersCatalog view
sysobjectssys.objectsCatalog view
syspermissionssys.database_permissions

 sys.server_permissions
Catalog view

Catalog view
sysprotectssys.database_permissions

 sys.server_permissions
Catalog view

Catalog view
sysreferencessys.foreign_keysCatalog view
systypessys.typesCatalog view
sysuserssys.database_principalsCatalog view
sysfulltextcatalogssys.fulltext_catalogsCatalog view

Catalog Views (Transact-SQL)
Dynamic Management Views and Functions (Transact-SQL)
System Tables (Transact-SQL)

Vsebina skupnosti

Dodaj
Pokaži:
© 2016 Microsoft