Catalog Views (Transact-SQL)

Catalog views return information that is used by the Microsoft SQL Server 2005 Database Engine. We recommend that you use catalog views because they are the most general interface to the catalog metadata and provide the most efficient way to obtain, transform, and present customized forms of this information. All user-available catalog metadata is exposed through catalog views.

Some catalog views inherit rows from other catalog views. For example, the sys.tables catalog view inherits from the sys.objects catalog view. The sys.objects catalog view is referred to as the base view, and the sys.tables view is called the derived view. The sys.tables catalog view returns the columns that are specific to tables and also all the columns that the sys.objects catalog view returns. The sys.objects catalog view returns rows for objects other than tables, such as stored procedures and views. After a table is created, the metadata for the table is returned in both views. Although the two catalog views return different levels of information about the table, there is only one entry in metadata for this table with one name and one object_id. This can be summarized as follows:

• The base view contains a subset of columns and a superset of rows.
• The derived view contains a superset of columns and a subset of rows.

The catalog views in SQL Server 2005 have been organized into the following categories:

See Also

Reference

Information Schema Views (Transact-SQL)
System Tables (Transact-SQL)

Other Resources

Querying the SQL Server System Catalog
Querying the SQL Server System Catalog FAQ
Troubleshooting Metadata Visibility

Help and Information

Getting SQL Server 2005 Assistance

Change History