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

# SHOW SCHEMAS

## Synopsis

```sql theme={null}
SHOW SCHEMAS [ FROM catalog ] [ LIKE pattern ]
```

## Description

List the schemas in `catalog` or in the current catalog.

[Specify a pattern](/sql/functions/comparison#pattern-comparison-like) in the optional `LIKE` clause to
filter the results to the desired subset. For example, the following query
allows you to find schemas that have `3` as the third character:

```sql theme={null}
SHOW SCHEMAS FROM tpch LIKE '__3%'
```