Purpose
This statement is used to delete an external data catalog.
Privilege requirements
To execute the DROP CATALOG statement, the current user must have the CREATE CATALOG privilege. For more information about OceanBase Database privileges, see Privilege classification in MySQL-compatible mode.
Syntax
DROP CATALOG [IF EXISTS] external_catalog_name;
Parameters
| Parameter | Description |
|---|---|
| IF EXISTS | Optional. If you specify IF EXISTS, the statement will not return an error if the external data catalog does not exist. If you do not specify this option, an error will be returned. |
| external_catalog_name | The name of the external data catalog to be deleted. |
Examples
DROP CATALOG test_odps_catalog;