DESCRIBE SCHEMAS¶

The DESCRIBE SCHEMAS command lets you list information about schemas in your cluster.

Note

DESCRIBE commands use CPU to increase usability.

Syntax¶

DESC[RIBE] SCHEMAS [DATABASE <database_name>] [LIKE 'pattern']

Parameters¶

Parameter	Parameter Type	Description
`DATABASE`	Identifier	Filters by a specific database
`LIKE`	STRING literal	String pattern to match

Output¶

Parameter	Description	Type
`schema_id`	Displays the schema ID	`INTEGER`
`schema_name`	Displays the schema name	`TEXT`
`schema_owner`	Displays the schema owner	`TEXT`

Examples¶

DESCRIBE SCHEMAS DATABASE master;

schema_id|schema_name|schema_owner|
---------+-----------+------------+
0        |public     |sqream      |
1        |staging_new|            |
4        |stage      |            |
5        |staging_1  |            |
6        |staging_2  |            |

DESCRIBE SCHEMAS DATABASE master LIKE '%stag%';

schema_id|schema_name|schema_owner|
---------+-----------+------------+
1        |staging_new|            |
4        |stage      |            |
5        |staging_1  |            |
6        |staging_2  |            |

Permissions¶

This command requires CONNECT permission on the database level.