For AI agents: A markdown version of this page is available at https://docs.datadoghq.com/ddsql_reference/data_directory/dd/dd.sqlserver_schemas.dataset.md. A documentation index is available at /llms.txt.

SQL Server Schemas

The SQL Server Schemas table provides metadata about database schemas discovered in SQL Server databases. Each row represents a schema and includes information such as schema name, owner, and a join key to navigate up the hierarchy to the logical database. This table enables you to inventory database schemas, analyze schema ownership, and walk the hierarchy (schema to logical database to database instance).

dd.sqlserver_schemas

Fields

TitleIDTypeData TypeDescription
Key_keycorestringUnique identifier for the SQL Server schema record.
Schema Nameschema_namecorestringName of the database schema.
Display Namedisplay_namecorestringHuman-readable display name for the schema.
OwnerownercorestringOwner of the schema.
IDidcorestringInternal identifier for the schema.
SQL Server Logical Database Keysqlserver_logical_database_keycorestringUsed to join this schema to dd.sqlserver_logical_databases to get logical database name and walk the hierarchy (schema to logical database to database instance).