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

SQL Server Tables

The SQL Server Tables table provides metadata about database tables discovered in SQL Server databases. Each row represents a table and includes information such as columns, indexes, foreign keys, and partitioning. This table enables you to inventory database schemas, track table modifications, analyze table structures, and monitor database metadata across your SQL Server infrastructure.

dd.sqlserver_tables

Fields

TitleIDTypeData TypeDescription
Key_keycorestringUnique identifier for the SQL Server table record.
Table Nametable_namecorestringName of the database table.
Display Namedisplay_namecorestringHuman-readable display name for the table.
ColumnscolumnscorejsonJSON array containing column definitions including name, data type, nullability, and default values.
IndexesindexescorejsonJSON array containing index definitions including name, columns, and uniqueness.
Foreign Keysforeign_keyscorejsonJSON array containing foreign key constraints and referenced tables.
IDidcorestringInternal identifier for the table.
Number of Partitionsnum_partitionscoreint64Number of partitions for the table.
SQL Server Schema Keysqlserver_schema_keycorestringUsed to join this table to dd.sqlserver_schemas to get schema name and walk the hierarchy (table to schema to logical database to database instance).