DROP FOREIGN TABLE¶
Function¶
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 executed.
Syntax¶
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:
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)