YMatrix

Quick Start

Cluster Deployment

Data Model

Data Writing

Data Query

SQL Reference

Maintenance and Monitoring

Tool Guide

Troubleshooting

Scenario
Version Release History

DROP FOREIGN DATA WRAPPER

Delete external data wrapper.

Summary

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

describe

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