---
title: SQL Server Tables
description: Datadog, the leading service for cloud-scale monitoring.
breadcrumbs: Docs > DDSQL Reference > Data Directory > SQL Server Tables
---

# 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

| Title                 | ID                   | Type | Data Type | Description                                                                                                                                           |
| --------------------- | -------------------- | ---- | --------- | ----------------------------------------------------------------------------------------------------------------------------------------------------- |
| Key                   | _key                 | core | string    | Unique identifier for the SQL Server table record.                                                                                                    |
| Table Name            | table_name           | core | string    | Name of the database table.                                                                                                                           |
| Display Name          | display_name         | core | string    | Human-readable display name for the table.                                                                                                            |
| Columns               | columns              | core | json      | JSON array containing column definitions including name, data type, nullability, and default values.                                                  |
| Indexes               | indexes              | core | json      | JSON array containing index definitions including name, columns, and uniqueness.                                                                      |
| Foreign Keys          | foreign_keys         | core | json      | JSON array containing foreign key constraints and referenced tables.                                                                                  |
| ID                    | id                   | core | string    | Internal identifier for the table.                                                                                                                    |
| Number of Partitions  | num_partitions       | core | int64     | Number of partitions for the table.                                                                                                                   |
| SQL Server Schema Key | sqlserver_schema_key | core | string    | Used 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). |