Help Center> Data Warehouse Service> SQL Syntax Reference> DDL Syntax> DROP FOREIGN TABLE
View PDF

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 table.

    Value range: An existing table name.

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

Examples

See Examples and Examples for CREATE FOREIGN TABLE.

Helpful Links

ALTER FOREIGN TABLE (For GDS), ALTER FOREIGN TABLE (For HDFS or OBS), CREATE FOREIGN TABLE (for GDS Import and Export), CREATE FOREIGN TABLE (SQL on Hadoop or OBS)

Parent topic: DDL Syntax