DROP EXTERNAL TABLE

Delete external table definitions.

Summary

DROP EXTERNAL [WEB] TABLE [IF EXISTS] name [CASCADE | RESTRICT]

describe

DROP EXTERNAL TABLE Deletes existing external table definitions from the database system. External data sources or files will not be deleted. To execute this command, you must be the owner of the external table.

Parameters

WEB

Optional keywords for deleting external web tables.

IF EXISTS

If the external table does not exist, do not report an error. In this case, a notification will be issued.

name

The name of the existing external table (can be specified by the schema).

CASCADE

Automatically delete objects (such as views) that depend on external tables.

RESTRICT

If any object depends on an external table, it is rejected. This is the default value.

Example

Delete an external table named staging (if it exists):

DROP EXTERNAL TABLE IF EXISTS staging;

compatibility