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 DBA authority, 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: