Description

SHOW SCHEMAS IN CATALOG is a SQL command used to display a list of all schemas defined in the specified catalog. Schemas are typically used to organize tables and views in a database, grouping them logically.

Syntax

SHOW SCHEMAS [EXTENDED] IN catalog_name;

Parameter Description

• catalog_name: Specifies the catalog name for listing schemas. The user must ensure that the provided catalog name exists and is accessible in the system.
• EXTENDED: Can display more information

Example

Example 1

SHOW SCHEMAS IN my_catalog;
+---------------------------------------------------------------------------+
|                                schema_name                                |
+---------------------------------------------------------------------------+
| air_travel                                                                |
| all_data                                                                  |
| automobile                                                                |
| automv_schema                                                             |
| bigquant                                                                  |
+---------------------------------------------------------------------------+

Example 2

SHOW SCHEMAS  EXTENDED IN my_catalog;
+---------------------------------------------------------------------------+----------+
|                                schema_name                                |   type   |
+---------------------------------------------------------------------------+----------+
| air_travel                                                                | managed  |
| all_data                                                                  | managed  |
| automobile                                                                | managed  |
| external_hive_schema                                                      | external |
+---------------------------------------------------------------------------+----------+