Help Center/ GaussDB/ Developer Guide(Centralized_2.x)/ SQL Reference/ SQL Syntax/ DROP FOREIGN TABLE
Updated on 2023-10-23 GMT+08:00
View PDF
Share

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.

Helpful Links

ALTER FOREIGN TABLE and CREATE FOREIGN TABLE

Parent topic: SQL Syntax