# LMV\_LOCAL\_DATABASES

This view shows all databases in a cluster and their current states.

| Column Name     | Description                                                                                                                                                                                                        |
| --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `DATABASE_NAME` | The name of the related database.                                                                                                                                                                                  |
| `STATE`         | Current state of the database (see[Database States](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-databases/#UUID-aff25cb0-4ba0-b92f-53be-6f30ee893f0f.md)for more information). |

***

Modified at: January 9, 2026

Source: [/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/lmv-local-databases/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/lmv-local-databases/)

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