DROP FUNCTION function_name
This statement drops the user-defined function (UDF) named
To drop a function, you must have the
DELETE privilege for the
mysql system schema. This is because
DROP FUNCTION removes a row from
mysql.func system table that records the
function's name, type, and shared library name.
To upgrade the shared library associated with a UDF, issue a
DROP FUNCTION statement,
upgrade the shared library, and then issue a
CREATE FUNCTION statement. If
you upgrade the shared library first and then use
DROP FUNCTION, the server may
DROP FUNCTION is also used to
drop stored functions (see Section 13.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”).