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

SHOW SCHEMAS FROM name

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

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 MovR: A Global Vehicle-sharing App.

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

copy
icon/buttons/copy
$ cockroach demo

Show schemas in the current database

copy
icon/buttons/copy
> CREATE SCHEMA org_one;
copy
icon/buttons/copy
> SHOW SCHEMAS;
     schema_name
----------------------
  crdb_internal
  information_schema
  org_one
  pg_catalog
  pg_extension
  public
(6 rows)

See also



Yes No