DROP FOREIGN TABLE

Function

DROP FOREIGN TABLE deletes a foreign table.

Precautions

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

Syntax

1
2

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

Parameter Description

• IF EXISTS

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

• table_name

  Specifies the name of the table to be deleted.

  Value range: an existing table name

• CASCADE | RESTRICT
  • CASCADE: automatically deletes the objects (such as views) that depend on the table.
  • RESTRICT: refuses to delete the table if any objects depend on it. This is the default action.

Examples

See Examples in CREATE FOREIGN TABLE.

Helpful Links

ALTER FOREIGN TABLE (for Import and Export) and CREATE FOREIGN TABLE (for Import and Export)