SHOW SCHEMAS

The SHOW SCHEMAS lists all in a database.

Required privileges

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

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

To follow along, run to start a temporary, in-memory cluster with the 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)