DROP EXTERNAL TABLE
Removes an external table definition.
Synopsis
DROP EXTERNAL [WEB] TABLE [IF EXISTS] <name> [CASCADE | RESTRICT]
Description
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.
Parameters
Examples
Remove the external table named staging
if it exists:
DROP EXTERNAL TABLE IF EXISTS staging;
Compatibility
There is no DROP EXTERNAL TABLE
statement in the SQL standard.