# SHOW SCHEMAS

Shows the list of schemas that exist on this SingleStore instance.

## Syntax

```

SHOW SCHEMAS
[LIKE 'pattern']

```

## Remarks

* `pattern` - SQL LIKE clause
* This command must be run on the master aggregator or a child aggregator node (see [Node Requirements for SingleStore Commands](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md)).

## Example

```

SHOW SCHEMAS;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| memsql             |
| test               |
+--------------------+
3 rows in set (0.00 sec)

```

***

Modified at: June 22, 2022

Source: [/db/v9.1/reference/sql-reference/show-commands/show-schemas/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-schemas/)

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