> For the complete documentation index, see [llms.txt](https://docs.deltastream.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.deltastream.io/reference/sql-syntax/command/list-databases.md).

# LIST DATABASES

## Syntax

```sql
[ LIST | SHOW ] DATABASES;
```

## Description

This command provides a list of [databases](/overview/core-concepts/databases.md) within the [organization](/overview/core-concepts/access-control.md#_organiation).

A database is listed only if the current role has USAGE privileges.

## Examples

```sh
demodb.public/demostore# LIST DATABASES;
+------------+-------------+------------+-------------------------------+
|  Name      |  Is Default |  Owner     |  Created At                   |
+============+=============+============+===============================+
| demodb     | true        | sysadmin   | 2024-07-02 16:23:26 +0000 UTC |
+------------+-------------+------------+-------------------------------+
| otherdb    | false       | sysadmin   | 2024-06-28 21:21:18 +0000 UTC |
+------------+-------------+------------+-------------------------------+
```