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¶
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.
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)