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.

    Do not throw an error if the external table does not exist. A notice is issued in this case.

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

    CASCADE

    RESTRICT

    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:

    See Also