Description

drops an existing external table definition from the database system. The external data sources or files are not deleted. To run this command you must be the owner of the external table.

WEB

Optional keyword for dropping external web tables.

IF EXISTS

name

The name (optionally schema-qualified) of an existing external table.

CASCADE

Automatically drop objects that depend on the external table (such as views).

Refuse to drop the external table if any objects depend on it. This is the default.

Examples

Remove the external table named if it exists:

There is no statement in the SQL standard.

See Also

CREATE EXTERNAL TABLE,