Purpose
You can use this statement to delete an external data catalog.
Note
For OceanBase Database V4.3.5, the DROP CATALOG statement is supported starting from V4.3.5 BP2.
Required privileges
To execute the DROP CATALOG statement, the current user must have the CREATE CATALOG privilege. For more details about OceanBase Database privileges, see Privilege types in MySQL-compatible mode.
Syntax
DROP CATALOG [IF EXISTS] external_catalog_name;
Parameters
| Parameter | Description |
|---|---|
| IF EXISTS | Optional. If IF EXISTS is specified, no error will be reported even if the external catalog to be deleted does not exist. If not specified, an error will be reported. |
| external_catalog_name | Specifies the name of the external catalog to be deleted. |
Example
DROP CATALOG test_odps_catalog;