DROP FOREIGN TABLE
remove a foreign table
English manual coverage begins with PostgreSQL 6.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- anchor
- SQL-DROPFOREIGNTABLE
- file
- sql-dropforeigntable.html
- lang
- en
- name
- DROP FOREIGN TABLE
- purpose
- remove a foreign table
- purpose zh
- 移除一个外部表
- sections same as
- Unknown
- slug
- 18
- synopsis html
- DROP FOREIGN TABLE [ IF EXISTS ] <em class="replaceable"><code>name</code></em> [, ...] [ CASCADE | RESTRICT ]
- synopsis text
- DROP FOREIGN TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
Syntax
DROP FOREIGN TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]Syntax diagrams
Read left to right. Branches are choices, bypasses are optional, loops repeat. Select an underlined parameter to open its rule.
Definition PG 18
DROP FOREIGN TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
Description
DROP FOREIGN TABLE removes a foreign table. Only the owner of a foreign table can remove it.
Parameters
IF EXISTSDo not throw an error if the foreign table does not exist. A notice is issued in this case.
nameThe name (optionally schema-qualified) of the foreign table to drop.
CASCADEAutomatically drop objects that depend on the foreign table (such as views), and in turn all objects that depend on those objects (see Section 5.15).
RESTRICTRefuse to drop the foreign table if any objects depend on it. This is the default.
Examples
To destroy two foreign tables, films and distributors:
DROP FOREIGN TABLE films, distributors;
Compatibility
This command conforms to ISO/IEC 9075-9 (SQL/MED), except that the standard only allows one foreign table to be dropped per command, and apart from the IF EXISTS option, which is a PostgreSQL extension.
See Also
ALTER FOREIGN TABLE, CREATE FOREIGN TABLECompare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:f6de544085bbff08affdfb16c7243c1cb7e9e1117d3a5b4bf6cad40f037231ae
Text language: en · wiki-repair-20261023:f6de544085bbff08affdfb16c7243c1cb7e9e1117d3a5b4bf6cad40f037231ae