ASA SQL User's Guide
Using Procedures, Triggers, and Batches
Introduction to user-defined functions
Once you create a user-defined function, it remains in the database until someone explicitly removes it. Only the owner of the function or a user with DBA authority can drop a function from the database.
The following statement removes the function fullname from the database:
DROP FUNCTION fullname