MySQL 8.4 Release Notes
The DROP FUNCTION
statement is used
to drop stored functions and loadable functions:
For information about dropping stored functions, see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”.
For information about dropping loadable functions, see Section 15.7.4.2, “DROP FUNCTION Statement for Loadable Functions”.