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:
If multiple functions share the same name, specify the argument types of the function you wish to drop.
You do not need to include an arg‑list when dropping a polymorphic function. |
Privileges
One of the following:
- Superuser
- Schema or function owner
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