This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Microsoft SQL Server provides the following collections of system views that expose metadata.
Information Schema Views
Dynamic Management Views and Functions
Data-tier Application Views (Transact-SQL)
System Tables (Transact-SQL)
Mapping System Tables to System Views (Transact-SQL)
Querying the SQL Server System Catalog FAQ
Metadata Access, Isolation Levels, and Lock Hints