United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2012

Product Documentation

Books Online for SQL Server 2012

Database Engine

Transact-SQL Reference (Database Engine)

System Views (Transact-SQL)

Catalog Views (Transact-SQL)

Compatibility Views (Transact-SQL)

Data-tier Application Views (Transact-SQL)

Dynamic Management Views and Functions (Transact-SQL)

Information Schema Views (Transact-SQL)

Querying the SQL Server System Catalog FAQ

Metadata Access, Isolation Levels, and Lock Hints

Minimize

3 out of 4 rated this helpful - Rate this topic

System Views (Transact-SQL)

SQL Server 2012

SQL Server 2005

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)

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

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.

|

Site Feedback

© 2013 Microsoft. All rights reserved.