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

# 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

| Title                           | ID                             | Type | Data Type | Description                                                                                                                                                       |
| ------------------------------- | ------------------------------ | ---- | --------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Key                             | _key                           | core | string    | Unique identifier for the SQL Server schema record.                                                                                                               |
| Schema Name                     | schema_name                    | core | string    | Name of the database schema.                                                                                                                                      |
| Display Name                    | display_name                   | core | string    | Human-readable display name for the schema.                                                                                                                       |
| Owner                           | owner                          | core | string    | Owner of the schema.                                                                                                                                              |
| ID                              | id                             | core | string    | Internal identifier for the schema.                                                                                                                               |
| SQL Server Logical Database Key | sqlserver_logical_database_key | core | string    | Used 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). |