Description
This statement is used to drop 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 AI Database privileges, see Permission classification.
Syntax
DROP CATALOG [IF EXISTS] external_catalog_name;
Parameters
Parameters |
Description |
|---|---|
| IF EXISTS | Optional. If specified, IF EXISTS. If the external data directory to be deleted does not exist, no error is reported. If it is not specified, an error will be reported. |
| external_catalog_name | Specifies the name of the external data directory to be deleted. |
Examples
DROP CATALOG test_odps_catalog;