DROP CATALOG
Updated at:
Copy as 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 |
|
|
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
Is this page helpful?