Release History
Help

YMatrix

Quick Start

Deployment

Data Usage

Manage Clusters

Security

Best Practice

Technical Principles

Advanced Features

Guide

SQL Reference

FAQ

DROP FOREIGN DATA WRAPPER

Delete external data wrapper.

Synopsis

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

Description

DROP FOREIGN DATA WRAPPER removes existing external data wrappers from the current database. External data wrappers can only be deleted by their owners.

Parameters

IF EXISTS

  • If the external data wrapper does not exist, do not report an error. In this case, the YMatrix database will issue a notification.

name

  • The name of the existing external data wrapper.

CASCADE

  • Automatically delete objects (such as servers) that depend on external data wrappers.

RESTRICT

  • Delete external data wrapper if any object depends on it. This is the default value.

Example

Delete an external data wrapper named dbi:

DROP FOREIGN DATA WRAPPER dbi;

Compatibility

DROP FOREIGN DATA WRAPPER complies with ISO/IEC 9075-9 (SQL/MED). The IF EXISTS clause is a YMatrix database extension.

See also

ALTER FOREIGN DATA WRAPPER , CREATE FOREIGN DATA WRAPPER

← Previous
DROP_EXTERNAL_TABLE
Next →
DROP_FOREIGN_TABLE