Purpose
You can execute this statement to drop an external data catalog.
Note
The DROP CATALOG statement is supported in OceanBase Database V4.3.5 and later, starting from V4.3.5 BP2.
Privilege requirements
To execute the DROP CATALOG statement, the current user must have the CREATE CATALOG privilege. For more information about privileges in OceanBase Database, see Privilege types in Oracle-compatible mode.
Syntax
DROP CATALOG external_catalog_name;
Parameters
| Parameter | Description |
|---|---|
| external_catalog_name | The name of the external catalog to be dropped. |
Examples
DROP CATALOG test_odps_catalog;