Catalog Views were introduced by Microsoft in SQL Server 2005 to store the Meta data which is related to all databases in our server.
- Provide the most efficient way to access the metadata.
- Do not contain data about Database backup, Replication, and SQL Server Agent Catalog data.
List of few frequently used Catalog Views:
sys.objects — Contains all the database objects and their meta data.
sys.tables — Contains all the tables and their meta data.
sys.views — Contains all the views and their meta data.
sys.databases — Contains all the databases and their meta data.
sys.triggers — Contains all the Triggers and their meta data.
sys.indexes — Contains all the Indexes and their meta data.