DROP FILTER

Drops a User Defined Load Filter function from the Vertica catalog.

Syntax

DROP FILTER [schema.]filter-name()

Parameters

schema

Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example:

myschema.thisDbObject
filter‑name()

Specifies the filter function to drop. You must append empty parentheses to the function name.

Privileges

Only the superuser or owner can drop the filter function.

Example

The following command drops the Iconverter filter function::

=> drop filter Iconverter();
DROP FILTER