DROP LOCAL DATA WRAPPER removes the definition of a data wrapper that was recorded by Create Local Data Wrapper.
DROP LOCAL DATA WRAPPER <wrappername> [ CASCADE | RESTRICT ]
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.
-- 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