Događaji
M03 31 23 - M04 2 23
Najveći događaj učenja jezika SQL, platforme Fabric i platforme Power BI. 31. mart - 2. april Koristite kod FABINSIDER da uštedite 400 dolara.
Registrirajte se danasOvaj preglednik više nije podržan.
Nadogradite na Microsoft Edge da iskoristite najnovije osobine, sigurnosna ažuriranja i tehničku podršku.
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 |
Catalog Views (Transact-SQL)
Dynamic Management Views and Functions (Transact-SQL)
System Tables (Transact-SQL)
Događaji
M03 31 23 - M04 2 23
Najveći događaj učenja jezika SQL, platforme Fabric i platforme Power BI. 31. mart - 2. april Koristite kod FABINSIDER da uštedite 400 dolara.
Registrirajte se danas