Once a user-defined function is created, it remains in the database until it is explicitly removed. 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
