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)