top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What are Catalog view in SQL server ?

+3 votes
284 views
What are Catalog view in SQL server ?
posted Oct 16, 2015 by Shivaranjini

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Catalog views return information used by the SQL Server. They are the most general interface to the catalog metadata and provide efficient way to obtain, transform and present custom forms of this information. They however, do not contain information about replication, backup or maintenance plans etc.

Purpose to use catalog views:

Access to metadata of databases

Most efficient way to access server metadata

Catalog view names and column names are descriptive, which enables a user to query what is expected without having extreme knowledge corresponding to metadata.

answer Oct 19, 2015 by Manikandan J
...