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

Delete the foreign table named customer_ft:

1

DROP FOREIGN TABLE customer_ft;

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 OBS or Hadoop)