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

# MySQL Tables

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

```
dd.mysql_tables
```

## Fields

| Title                      | ID                         | Type | Data Type | Description                                                                                                                                         |
| -------------------------- | -------------------------- | ---- | --------- | --------------------------------------------------------------------------------------------------------------------------------------------------- |
| Key                        | _key                       | core | string    | Unique identifier for the MySQL 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.                                                                                |
| Engine                     | engine                     | core | string    | Storage engine used by the table (e.g., InnoDB).                                                                                                    |
| Row Format                 | row_format                 | core | string    | Row storage format (e.g., Dynamic).                                                                                                                 |
| Partitions                 | partitions                 | core | json      | JSON array containing partition definitions.                                                                                                        |
| Create Time                | create_time                | core | timestamp | Timestamp when the table was created.                                                                                                               |
| MySQL Logical Database Key | mysql_logical_database_key | core | string    | Used to join this table to dd.mysql_logical_databases to get database name and walk the hierarchy (table to logical database to database instance). |