Removes a foreign table.
DROP FOREIGN TABLE [ IF EXISTS ] <name> [, ...] [ CASCADE | RESTRICT ]
DROP FOREIGN TABLE removes an existing foreign table. Only the owner of a foreign table can remove it.
Drop the foreign tables named
DROP FOREIGN TABLE films, distributors;
DROP FOREIGN TABLE conforms to ISO/IEC 9075-9 (SQL/MED), except that the standard only allows one foreign table to be dropped per command. The
IF EXISTS clause is a Greenplum Database extension.
Parent topic: SQL Commands