DROP TRANSFORM FUNCTION

Drops a user-defined transform function (UDTF) from the Vertica catalog.

Syntax

DROP TRANSFORM FUNCTION [ IF EXISTS ] [[database.]schema.]function( [ arg‑list ] )

`IF EXISTS`	Specifies not to report an error if the function to drop does not exist. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them.
`[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	Specifies the transform 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: arg‑name is typically a column name. arg‑type is the name of an SQL data type supported by Vertica. You can omit arg‑list when dropping a polymorphic function.

One of the following:

The following command drops the tokenize UDTF in the macros schema:

=> DROP TRANSFORM FUNCTION macros.tokenize(varchar);
DROP TRANSFORM FUNCTION

The following command drops the Pagerank polymorphic function in the online schema:

=> DROP TRANSFORM FUNCTION online.Pagerank();
DROP TRANSFORM FUNCTION