What are Catalog Views?

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.

Leave a Reply

Your email address will not be published. Required fields are marked *