Dropping User-Defined Functions

Once you create a user-defined function, it remains in the database until it is explicitly removed. Only the owner of the function or procedure, or a user with the DROP ANY PROCEDURE or DROP ANY OBJECT system privilege, can drop a function or procedure from the database.

For example, to remove the scalar or aggregate function fullname from the database, enter:

DROP FUNCTION fullname

To remove a table UDF or TPF named fullname from the database, enter:

DROP PROCEDURE fullname