YMatrix

Version Release History
Platform Requirements

YMatrix

Quick Start

Standard Cluster Deployment

Data Modeling

Connecting to The database

Data Writing

Data Migration

Data Query

Maintenance and Monitoring

Performance Tuning

Troubleshooting

Reference Guide

SQL Reference

FAQ

scenario

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