DROP EXTERNAL TABLE
Removes an external table definition.
DROP EXTERNAL [WEB] TABLE [IF EXISTS] <name> [CASCADE | RESTRICT]
DROP EXTERNAL TABLE drops an existing external table definition from the database system. The external data sources or files are not deleted. To execute this command you must be the owner of the external table.
Remove the external table named
staging if it exists:
DROP EXTERNAL TABLE IF EXISTS staging;
There is no
DROP EXTERNAL TABLE statement in the SQL standard.