DROP FUNCTION

Synopsis

DROP FUNCTION function_name (arg_name arg_type [, ...]);

Description

Drops an existing user-defined Function. The Function's name and its list of arguments (as specified when the Function was created using the CREATE FUNCTION statement) should be provided for identifying the Function. This statement can only be executed by the Function owner.

DROP FUNCTION cannot be undone. Use it with care!

Arguments

function_name

The name of the Function to drop. For case-sensitive names, the name must be wrapped in double quotes, otherwise, the lowercased name will be used.

(arg_name arg_type [,…​])

An ordered list of Function argument names and types.

Example

Drop a Function

Assume a user-defined Function, named touppercase, is created using the CREATE FUNCTION statement and is now available:

db1.public/my_store# CREATE FUNCTION toUpperCase (s VARCHAR) RETURNS VARCHAR LANGUAGE JAVA WITH ('source.name' = 'mysrc', 'class.name' = 'util.UpperCase');
db1.public/my_store# LIST FUNCTIONS;
  Source |     Class      |           Signature            |  Owner   |      Created at      |      Updated at       
---------+----------------+--------------------------------+----------+----------------------+-----------------------
  mysrc  | util.UpperCase | touppercase(s VARCHAR) VARCHAR | sysadmin | 2022-12-22T21:33:45Z | 2022-12-22T21:33:45Z  

This Function can be dropped with the below statement:

db1.public/my_store# DROP FUNCTION toUpperCase (s VARCHAR);
db1.public/my_store# LIST FUNCTIONS;
  Source | Class | Signature | Owner | Created at | Updated at  
---------+-------+-----------+-------+------------+-------------