SHOW SCHEMAS

On this page Carat arrow pointing down
Warning:
CockroachDB v2.0 is no longer supported as of October 4, 2019. For more details, refer to the Release Support Policy.

New in v2.0: The SHOW SCHEMAS statement lists all schemas in a database.

Required Privileges

No privileges are 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

> SET DATABASE = bank;
> SHOW SCHEMAS;
+--------------------+
|       Schema       |
+--------------------+
| crdb_internal      |
| information_schema |
| pg_catalog         |
| public             |
+--------------------+
(4 rows)

See Also


Yes No
On this page

Yes No