DROP CATALOG

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 seekdb privileges, see seekdb privilege types.

Syntax

DROP CATALOG [IF EXISTS] external_catalog_name;

Parameters

Parameter	Description
IF EXISTS	Optional. If specified, the statement will not return an error when the external data catalog does not exist. If not specified, an error will be returned.
external_catalog_name	The name of the external data catalog to be dropped.

Examples

DROP CATALOG test_odps_catalog;