Updated on 2023-10-23 GMT+08:00

DROP FOREIGN TABLE

Function

DROP FOREIGN TABLE 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.

Syntax

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

    Table name

    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.