SQL Server Catalog Views

SQL Server > Catalog Views

Catalog views return information that is used by the SQL Server Database Engine.

• It is recommend that you query the catalog views instead of system tables
• It is recommend using SELECT * FROM sys.catalog_view_name because the number of columns returned might change

List of catalog views:

• Database mail
• sys.dataspaces
• sys.schemas
• sys.columns