© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
P. A. CarterPro SQL Server 2022 Administrationhttps://doi.org/10.1007/978-1-4842-8864-1_18

18. SQL Server Metadata

Peter A. Carter1  
(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 described 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 ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.