Vertica Analytics Platform Version 9.2.x Documentation

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 ] )

Parameters

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.

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