Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Removes a function from the database.
DROP FUNCTION [ IF EXISTS ] [ owner.]function-name
If you do not want an error returned when the DROP FUNCTION statement attempts to remove a function that does not exist, then use the IF EXISTS clause.
You must be the owner of the function, or have the DROP ANY PROCEDURE or DROP ANY OBJECT system privilege.
Core Feature. The IF EXISTS clause is not in the standard.
This example drops the fictitious function, MyFunction, from the database.
DROP FUNCTION MyFunction;