Catalog Views Overview
Catalog views return server state information that can be used to monitor the health of a SQL Server instance and to diagnose problems. They expose metadata about databases, objects, permissions, and more.
| View | Description |
|---|---|
| sys.databases | Information about each database in the instance. |
| sys.objects | All schema-scoped objects in the database. |
| sys.columns | Columns for each object that has columns. |
| sys.indexes | Indexes on tables and views. |
| sys.schemas | Database schemas. |
| sys.views | All views defined in the database. |
| sys.procedures | Stored procedures. |
| sys.parameters | Parameters for stored procedures and functions. |