DROP FOREIGN DATA WRAPPER
remove a foreign-data wrapper
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-DROPFOREIGNDATAWRAPPER
- file
- sql-dropforeigndatawrapper.html
- lang
- en
- name
- DROP FOREIGN DATA WRAPPER
- purpose
- remove a foreign-data wrapper
- purpose zh
- 移除一个外部数据包装器
- sections same as
- Unknown
- slug
- 18
- synopsis html
- DROP FOREIGN DATA WRAPPER [ IF EXISTS ] <em class="replaceable"><code>name</code></em> [, ...] [ CASCADE | RESTRICT ]
- synopsis text
- DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
Syntax
DROP FOREIGN DATA WRAPPER [ 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 DATA WRAPPER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
Description
DROP FOREIGN DATA WRAPPER removes an existing foreign-data wrapper. To execute this command, the current user must be the owner of the foreign-data wrapper.
Parameters
IF EXISTSDo not throw an error if the foreign-data wrapper does not exist. A notice is issued in this case.
nameThe name of an existing foreign-data wrapper.
CASCADEAutomatically drop objects that depend on the foreign-data wrapper (such as foreign tables and servers), and in turn all objects that depend on those objects (see Section 5.15).
RESTRICTRefuse to drop the foreign-data wrapper if any objects depend on it. This is the default.
Examples
Drop the foreign-data wrapper dbi:
DROP FOREIGN DATA WRAPPER dbi;
Compatibility
DROP FOREIGN DATA WRAPPER conforms to ISO/IEC 9075-9 (SQL/MED). The IF EXISTS clause is a PostgreSQL extension.
See Also
CREATE FOREIGN DATA WRAPPER, ALTER FOREIGN DATA WRAPPERCompare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:f2b5b00f870221f08e56f7b664be2463bcf73bde6b11a0700302fc2fe285e05a
Text language: en · wiki-repair-20261023:f2b5b00f870221f08e56f7b664be2463bcf73bde6b11a0700302fc2fe285e05a