DROP FOREIGN TABLE

Description

Drops a foreign table.

Precautions

DROP FOREIGN TABLE forcibly drops the specified table and the indexes depending on the table. After the table is dropped, the functions and stored procedures that need to use this table cannot be executed.

In the multi-tenancy scenario, only the initial user can run the DROP FOREIGN TABLE command in the PDB.

Syntax

DROP FOREIGN TABLE [ IF EXISTS ] 
    table_name [, ...] [ CASCADE | RESTRICT ];

Parameters

• IF EXISTS

  Reports a notice instead of an error if the specified table does not exist.

• table_name

  Specifies the name of the table.

  Value range: an existing table name.

• CASCADE | RESTRICT

  • CASCADE: automatically drops the objects (such as views) that depend on the table.

  • RESTRICT: refuses to drop the table if any objects depend on it. This is the default action.

Examples

See Examples.

Helpful Links

ALTER FOREIGN TABLE and CREATE FOREIGN TABLE