DROP FILTER

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

Syntax

DROP FILTER [[database.]schema.]filter()

Parameters

[database.]schema

Database and schema. The default schema is public. If you specify a database, it must be the current database.

filter()

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

Privileges

Non-superuser:

• Owner or DROP privilege

• USAGE privilege on schema

Examples

The following command drops the Iconverter filter function::

=> drop filter Iconverter();
DROP FILTER

See also

• ALTER FUNCTION (scalar)
• CREATE FILTER
• USER_FUNCTIONS
• User-defined load (UDL)