DROP FUNCTION

Drops a SQL function or User Defined Function (UDF) from the Vertica catalog.

Syntax

DROP FUNCTION [[database.]schema.]function[,…] ( [ arg‑list ] )

[database.]schema

Specifies a schema, by default public. If schema is any schema other than public, you must supply the schema name. For example:

myschema.thisDbObject

If you specify a database, it must be the current database.

function The SQL function to drop.

arg‑list

A comma-delimited list of arguments as defined for this function when it was created, specified as follows:

[arg‑name] arg‑type[,…]

where arg‑name optionally qualifies arg‑type:

One of the following:

To drop a function, you must specify the argument types because several functions might share the same name with different parameters.
Vertica does not check for dependencies, so if you drop a SQL function where other objects reference it (such as views or other SQL functions), Vertica returns an error when those objects are used and not when the function is dropped.

The following command drops the zerowhennull function in the macros schema:

=>  DROP FUNCTION macros.zerowhennull(x INT);
DROP FUNCTION