System Views (Transact-SQL)

  • 2 minutes to read

Microsoft SQL Server provides the following collections of system views that expose metadata.

Catalog Views

Information Schema Views

Compatibility Views

Replication Views

Dynamic Management Views and Functions

Data-tier Application Views (Transact-SQL)

See Also

Reference

System Tables (Transact-SQL)

Mapping System Tables to System Views (Transact-SQL)

Concepts

Querying the SQL Server System Catalog FAQ

Metadata Access, Isolation Levels, and Lock Hints