SHOW SCHEMAS command

The SHOW SCHEMAS command returns information about the schemas in the current catalog that the current user can access. Schemas on which the user does not have USAGE are omitted.

Administrators and schema owners have implicit access, and every user can access /default_schema. For more information, see Schema access control.

The following table describes the returned information:

Column	Description
path	The path of the schema. The path is a logical path used to organize schemas.
owner	The owner of the schema.

Syntax

diagramsource

show_schemas_command

show_schemas_command ::=
    'SHOW' 'SCHEMAS'

Examples

Show accessible schemas

SHOW SCHEMAS

Return:

+-----------------+-------+
| path            | owner |
+-----------------+-------+
| /default_schema | root  |
+-----------------+-------+