SHOW SCHEMAS

The SHOW SCHEMAS statement lists all schemas in a database.

Required privileges

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

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

To follow along, run cockroach demo to start a temporary, in-memory cluster with the movr sample dataset preloaded:

$ cockroach demo

> CREATE SCHEMA org_one;

> SHOW SCHEMAS;

     schema_name
----------------------
  crdb_internal
  information_schema
  org_one
  pg_catalog
  pg_extension
  public
(6 rows)