© Peter A. Carter 2019
Peter A. CarterPro SQL Server 2019 Administrationhttps://doi.org/10.1007/978-1-4842-5089-1_17

17. SQL Server Metadata

Peter A. Carter
(1)
SOUTHAMPTON, UK
 
Metadata is data that describes other data. SQL Server exposes a vast array of metadata including structural metadata, which describes every object, and descriptive metadata, which describes the data itself. Metadata is exposed through a series of
  • Catalog views
  • Information schema views
  • Dynamic management views and functions
  • System functions
  • System stored procedures
In this chapter, we will discuss how metadata can be used to perform actions at the instance level, such as expose registry values, examine how metadata can assist in capacity planning, and discuss how metadata can ...

Get Pro SQL Server 2019 Administration: A Guide for the Modern DBA now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.