DROP FOREIGN TABLE¶
Drops a foreign table.
Synopsis¶
DROP FOREIGN TABLE [ IF EXISTS ] name [, ...]
Description¶
DROP FOREIGN TABLE is a DDL statement that removes a foreign table.
Dropping a foreign table requires AL permission on the table, the schema or
cluster level.
Parameters¶
- name:
The name of the table to drop. Separate multiple names by comma to drop multiple tables at once.
Clauses¶
IF EXISTS¶
By default DROP FOREIGN TABLE raises an error if the given tables don’t
exist. With the IF EXISTS clause the statement won’t raise an error if any
of the given tables don’t exist.