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)

Statements

Syntax

Data Types

Spatial Data

Constraints

Required privileges

Synopsis

Parameters

Example

Setup

Show schemas in the current database

See also

​Required privileges

​Synopsis

​Parameters

​Example

​Setup

​Show schemas in the current database

​See also

Required privileges

Synopsis

Parameters

Example

Setup

Show schemas in the current database

See also