> ## Documentation Index
> Fetch the complete documentation index at: https://docs.risingwave.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SHOW SCHEMAS

> Use the `SHOW SCHEMAS` command to show schemas in the `dev` database.

## Syntax

```sql theme={null}
SHOW SCHEMAS [ LIKE_expression ];
```

## Parameters

| Parameter or clause | Description                                                                                                                                                                  |
| :------------------ | :--------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| LIKE\_expression    | Filters the output based on names by applying pattern matching. See details in [LIKE pattern matching expressions](/sql/functions/string#like-pattern-matching-expressions). |

## Example

```bash theme={null}
SHOW SCHEMAS;
```