Removes a Blob filter declaration from a database. Available in
gpre, DSQL, and
DROP FILTER name;
Name of an existing Blob filter
DROP FILTER removes a Blob filter declaration from a database. Dropping a Blob filter declaration from a database does not remove it from the corresponding Blob filter library, but it does make the filter inaccessible from the database. Once the definition is dropped, any applications that depend on the filter will return run-time errors.
DROP FILTER fails and returns an error if any processes are using the filter.
A filter can be dropped by its creator, the SYSDBA user, or any user with operating system root privileges.
isql statement drops a Blob filter:
DROP FILTER DESC_FILTER;