SHOW SCHEMAS

On this page Carat arrow pointing down

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