Advertisement

Catalog Views and Dynamic aent Views

  • Miguel Cebollero
  • Jay Natarajan
  • Michael Coles
Chapter

Abstract

SQL Server has always offered access to metadata describing databases, tables, views, and other database objects. Prior to the introduction of catalog views in SQL Server 2005, the primary methods of accessing this metadata included system tables, system SPs, INFORMATION_SCHEMA views, and SQL Distributed Management Objects (SQL-DMO). Catalog views provide access to a richer set of detailed information than any of these options provided in previous SQL Server releases. SQL Server even includes catalog views that allow you to access server-wide configuration metadata.

Keywords

Partial Result Session Information System Table Query Plan Active Session 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Miguel Cebollero 2015

Authors and Affiliations

  • Miguel Cebollero
    • 1
  • Jay Natarajan
    • 1
  • Michael Coles
    • 1
  1. 1.ValricoUnited States

Personalised recommendations