DROP EXTERNAL TABLE

    Description

    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.

    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