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

# SQL Server Logical Databases

The SQL Server Logical Databases table provides metadata about logical databases discovered in SQL Server instances. Each row represents a logical database and includes information such as database name, collation, owner, and a join key to navigate up the hierarchy to the database instance. This table enables you to inventory logical databases, analyze database ownership, and walk the hierarchy (logical database to database instance). The whole hierarchy is sqlserver_tables → sqlserver_schemas → sqlserver_logical_databases → database_instances (4 tables).

```
dd.sqlserver_logical_databases
```

## Fields

| Title                 | ID                    | Type | Data Type | Description                                                                                                                                         |
| --------------------- | --------------------- | ---- | --------- | --------------------------------------------------------------------------------------------------------------------------------------------------- |
| Key                   | _key                  | core | string    | Unique identifier for the SQL Server logical database record.                                                                                       |
| Collation             | collation             | core | string    | Collation setting of the logical database.                                                                                                          |
| Database Name         | database_name         | core | string    | Name of the logical database.                                                                                                                       |
| Display Name          | display_name          | core | string    | Human-readable display name for the logical database.                                                                                               |
| ID                    | id                    | core | string    | Internal identifier for the logical database.                                                                                                       |
| Owner                 | owner                 | core | string    | Owner of the logical database.                                                                                                                      |
| Database Instance Key | database_instance_key | core | string    | Used to join this logical database to dd.database_instances to get instance details and walk the hierarchy (logical database to database instance). |