DROP FOREIGN DATA WRAPPER
Removes a foreign data wrapper.
Synopsis
DROP FOREIGN DATA WRAPPER [IF EXISTS] <name> [CASCADE | RESTRICT]Description
DROP FOREIGN DATA WRAPPER removes an existing foreign data wrapper from the current database.
A foreign data wrapper may be removed only by its owner.
Parameters
| Parameter | Description |
|---|---|
IF EXISTS |
Do not throw an error if the foreign data wrapper does not exist. Greengage DB issues a notice in this case |
name |
The name of an existing foreign data wrapper |
CASCADE |
Automatically drop objects that depend on the foreign data wrapper (such as servers) |
RESTRICT |
Refuse to drop the foreign data wrapper if any object depends on it. This is the default |
Examples
Drop the foreign data wrapper named 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 Greengage DB extension.