DROP LOCAL DATA WRAPPER

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > DROP statements >

DROP LOCAL DATA WRAPPER

Previous pageReturn to chapter overviewNext page

DROP LOCAL DATA WRAPPER removes the definition of a data wrapper that was recorded by Create Local Data Wrapper.

Syntax

DROP LOCAL DATA WRAPPER <wrappername> [ CASCADE | RESTRICT ]

droplocaldatawrapper

Notes

The local data wrapper cannot be dropped if any servers are defined that depend upon it - unless the CASCADE option is specified, in which case all dependent servers (and any objects depending on those servers, directly or indirectly) are dropped at the same time as the data wrapper. The default option is RESTRICT.

System-defined local wrappers should not be dropped. One example is SYS_JDBC.

Examples

-- Drop a wrapper that has no dependencies

DROP LOCAL DATA WRAPPER gmail;

-- Error if there are dependencies

DROP LOCAL DATA WRAPPER jms_bridge RESTRICT

-- Force drop all dependent servers, streams, tables

DROP LOCAL DATA WRAPPER esb_gateway CASCADE