DROP TRANSFORM FUNCTION

Drops a User Defined Transform Function (UDTF) from the Vertica catalog.

Syntax

DROP TRANSFORM FUNCTION [schema.]function‑name( [ arg‑list ] )

Parameters

schema

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

myschema.mytransformfunction

function‑name

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[,...]

If multiple functions share the same name, specify the argument types of the function you wish to drop.

  • arg-name is typically a column name. You (optionally) use an arg-name to qualify an arg-type.
  • arg-type is the name of an SQL data type supported by Vertica.

You do not need to include an arg‑list when dropping a polymorphic function.

Privileges

One of the following:

Example

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