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
Use the IF EXISTS clause if you do not want an error returned when the DROP FUNCTION statement attempts to remove a function
that does not exist.
DROP FUNCTION is prevented when the statement affects an object that is currently being used by another connection.
You must be the owner of the function, or have the DROP ANY PROCEDURE or DROP ANY OBJECT system privilege.
Automatic commit. Clears the Results tab in the Results pane in Interactive SQL.
Core feature. The IF EXISTS clause is a vendor extension.
This example drops the fictitious function, MyFunction, from the database.
DROP FUNCTION MyFunction;