DROP FUNCTION (Delete function)
Function
DROP FUNCTION deletes a function.
Privileges
The owner of a function can delete that function.
These users can delete functions that are owned by other users.
Format
DROP FUNCTION [authorization-identifier.] routine-identifier
([data-type [,data-type]...])
[WITH PROGRAM]
Operands
Specifies the data type that was specified in the parameter for the function that is to be deleted.
When deleting a function, this option is specified to nullify an SQL object for which any of the following functions, procedures, and triggers are in affect:
If WITH PROGRAM is omitted, and if there is an SQL object for which any of the following functions, procedures, and triggers are in effect, that function cannot be deleted:
Common rules
Notes