# SHOW SCHEMAS

The `SHOW SCHEMAS` statement lists all schemas in a database.

## Required privileges

The `SELECT` privilege on the database is required to list the schemas in a database.

## Synopsis

## Parameters

Parameter | Description
--- | ---
`name` | The name of the database for which to show schemas. When omitted, the schemas in the current database are listed.

## Example

    > SET DATABASE = bank;

    > SHOW SCHEMAS;

    +--------------------+
    |    schema_name     |
    +--------------------+
    | crdb_internal      |
    | information_schema |
    | pg_catalog         |
    | public             |
    +--------------------+
    (4 rows)

## See also

- Logical Schemas and Namespaces
- `SHOW DATABASES`
- Information Schema
- Other SQL Statements