System Catalog Views
The system catalog views expose metadata about the SQL Server instance, databases, and objects. Use them to query information about tables, columns, constraints, and more.
| View Name | Description | Category |
|---|---|---|
| sys.tables | Returns a row for each table object. | Objects |
| sys.columns | Returns a row for each column of objects that have columns. | Objects |
| sys.indexes | Returns a row for each index of tables and views. | Indexes |
| sys.database_principals | Returns a row for each database principal. | Security |
| sys.schemas | Returns a row for each schema in the database. | Objects |
| sys.procedures | Returns a row for each stored procedure object. | Objects |
| sys.types | Returns a row for each data type. | Types |
| sys.foreign_keys | Returns a row for each foreign key constraint. | Constraints |
| sys.check_constraints | Returns a row for each CHECK constraint. | Constraints |
| sys.default_constraints | Returns a row for each DEFAULT constraint. | Constraints |