DROP CATALOG

更新时间:
复制 MD 格式

DROP CATALOG removes the specified External Catalog. After the catalog is dropped, the metadata mapping is removed from AnalyticDB for MySQL, but the actual data in the external data source is not affected.

Syntax

DROP CATALOG <catalog_name>;

Parameters

Parameter

Required

Description

catalog_name

Yes

The name of the catalog to drop.

Examples

Drop the Paimon Catalog paimon_catalog_dlf:

DROP CATALOG paimon_catalog_dlf;

Usage notes

  • This command is supported since AnalyticDB for MySQL 3.2.7.

  • Only External Catalogs can be dropped. The Managed Catalog (adb) cannot be dropped.

  • Dropping a catalog only removes the metadata mapping within AnalyticDB for MySQL. The actual data in the external data source remains intact.

  • If the current session is using the catalog being dropped, you must switch to another catalog before proceeding.

Related documents