DROP FOREIGN TABLE deletes a specified foreign table.
DROP FOREIGN TABLE forcibly deletes a specific 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.
DROP FOREIGN TABLE [ IF EXISTS ] table_name [, ...] [ CASCADE | RESTRICT ];
Does not throw an error if the table does not exist. A notice is issued in this case.
Specifies the name of the table.
Value range: An existing table name.
See examples in CREATE FOREIGN TABLE (SQL on Hadoop or OBS).