DROP FOREIGN DATA WRAPPER

Function Description

Drops a foreign data wrapper (FDW).

Syntax

DropForeignDataWrapper ::= DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [ CASCADE | RESTRICT ]

Parameter Description

• name

  Specifies the name of an FDW to be dropped.

• CASCADE

  Automatically drops objects (such as servers) that depend on the FDW.

• RESTRICT

  Refuses to drop the FDW if there is any dependency on the FDW. This option is the default option.

Examples

--Create an FDW named dbi.
MogDB=# CREATE FOREIGN DATA WRAPPER dbi OPTIONS (debug 'true');
--Drop dbi.
MogDB=# DROP FOREIGN DATA WRAPPER dbi;