Help Center/Data Warehouse Service/SQL Syntax Reference (8.1.3.x)/DDL Syntax/DROP FOREIGN TABLE
Updated on 2025-06-12 GMT+08:00
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

Table 1 DROP FOREIGN TABLE parameters

Parameter

Description

Value Range

IF EXISTS

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

-

table_name

Specifies the name of the foreign table to be deleted.

An existing table name.

CASCADE | RESTRICT

Specifies how to process related data in the dependent object when a delete operation is performed.

  • 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;

Helpful Links

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

Parent Topic: DDL Syntax