`DROP FOREIGN TABLE`¶

Drops a foreign table.

Table of contents

Synopsis
Description
Parameters
Clauses
- IF EXISTS

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.

See also