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.

Synopsis

Parameters

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

Example

Setup

The following examples use MovR, a fictional vehicle-sharing application, to demonstrate CockroachDB SQL statements. For more information about the MovR example application and dataset, see .

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

$ cockroach demo

Show schemas in the current database

> CREATE SCHEMA org_one;

> SHOW SCHEMAS;

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

See also