Updated on 2024-09-02 GMT+08:00

DROP FOREIGN TABLE

Function

DROP FOREIGN TABLE deletes a specified foreign table.

Precautions

DROP FOREIGN TABLE forcibly deletes a specified table. After a table is deleted, any indexes that exist for the table will be deleted. The functions and stored procedures used in this table cannot be run.

Syntax

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

Parameter Description

  • IF EXISTS

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

  • table_name

    Specifies the name of the foreign table to be deleted.

    Value range: An existing table name.

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

Examples

Delete the foreign table named customer_ft:

1
DROP FOREIGN TABLE customer_ft;