DROP CATALOG
Description
This statement is used to delete the external catalog.
Syntax
DROP CATALOG [IF EXISTS] <catalog_name>;
Required Parameters
1. <catalog_name>
The name of the catalog to be dropped.
Access Control Requirements
| Privilege | Object | Notes |
|---|---|---|
| DROP_PRIV | Catalog | The DROP_PRIV permission for the corresponding catalog is required. |
Example
-
Drop catalog hive
DROP CATALOG hive;
