SHOW CATALOGS list all catalogs-AnalyticDB(AnalyticDB)-阿里云帮助中心

SHOW CATALOGS lists the name, type, and description of every catalog in the current AnalyticDB for MySQL instance.

Syntax

SHOW CATALOGS;

Output columns

Column	Type	Description
Catalog	VARCHAR	Catalog name.
Type	VARCHAR	Catalog type. Valid values: `Managed Catalog` and `External Catalog`.
Comment	VARCHAR	Catalog description. Defined by the `COMMENT` clause when you create an External Catalog.

Examples

List all catalogs in the current instance:

SHOW CATALOGS;

Sample output:

+------------+------------------+-----------------------------------------------------------------------------------+
| Catalog    | Type             | Comment                                                                           |
+------------+------------------+-----------------------------------------------------------------------------------+
| adb        | Managed Catalog  | A system built-in catalog contains this cluster's self-managed tables as default. |
| paimon_oss | External Catalog | NULL                                                                              |
+------------+------------------+-----------------------------------------------------------------------------------+
2 rows in set (0.10 sec)

Usage notes

This command is available since AnalyticDB for MySQL 3.2.7.

Syntax

Output columns

Examples

Usage notes

Related documents