On this page
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.
Synopsis
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
To follow along, run cockroach demo
to start a temporary, in-memory cluster with the movr
sample 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)