# DISTRIBUTED\_DATABASES

This view contains information about databases.

| Column Name                         | Description                                                                                                                                                    |
| ----------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `DATABASE_ID`                       | The unique`ID`of a given database.                                                                                                                             |
| `DATABASE_NAME`                     | The name of a given database.                                                                                                                                  |
| `NUM_PARTITIONS`                    | The number of a partitions in a given database.                                                                                                                |
| `NUM_SUB_PARTITIONS`                | The number of sub-partitions in a given database.                                                                                                              |
| `CLUSTER_ID`                        | The`ID`of the relatedclusterfor a given database.                                                                                                              |
| `REMOTE_NAME`                       | The remote name of a given database.                                                                                                                           |
| `IS_SYNC`                           | Determines if the database uses synchronous replication for high availability.                                                                                 |
| `IS_SYNC_DURABILITY`                | Determines if the database uses synchronous durability.                                                                                                        |
| `IS_PAUSED`                         | Whether DR replication of a given database is paused.                                                                                                          |
| `SITE_ID`                           | The ID for thecluster.                                                                                                                                         |
| `IS_SYNC_DURABILITY_ON_REF_DB_ONLY` | Indicates whether the reference database is sync durable despite the partition databases being async durable.                                                  |
| `STORAGE_ID`                        | Storage ID of the database.                                                                                                                                    |
| `SAFE_TS`                           | The lower bound of the pre-prepare timestamps of any unresolved 2PC their participants (reference and partition databases) participate or will participate in. |

***

Modified at: May 7, 2025

Source: [/db/v9.1/reference/information-schema-reference/cluster-component/distributed-databases/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/distributed-databases/)

(An index of the documentation is available at /llms.txt)