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