SHOW SCHEMAS

On this page Carat arrow pointing down
Warning:
As of November 12, 2021, CockroachDB v20.1 is no longer supported. For more details, refer to the Release Support Policy.

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

icon/buttons/copy
> SET DATABASE = bank;
icon/buttons/copy
> SHOW SCHEMAS;
+--------------------+
|    schema_name     |
+--------------------+
| crdb_internal      |
| information_schema |
| pg_catalog         |
| public             |
+--------------------+
(4 rows)

See also


Yes No
On this page

Yes No