Purpose
This statement is used to drop an external 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 mode.
Syntax
DROP CATALOG [IF EXISTS] external_catalog_name;
Parameters
| Parameter | Description |
|---|---|
| IF EXISTS | Optional. If specified, the statement will not return an error even if the external catalog does not exist. If not specified, an error will be returned. |
| external_catalog_name | The name of the external catalog to be dropped. |
Examples
DROP CATALOG test_odps_catalog;