Release History
Requirements

Introduction

Quick onboard

Deployment

Data Modeling

Connecting

Write data

Migration

Query

Operations and Maintenance

Performance Tuning

Troubleshooting

Reference 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