CREATE FUNCTION
CREATE FUNCTION creates a user-defined function (UDF), including scalar, aggregate, window, and table functions.
DROP FUNCTION
DROP FUNCTION deletes a custom function by matching name and parameter types.
SHOW CREATE FUNCTION
SHOW CREATE FUNCTION returns the CREATE FUNCTION DDL for a user-defined function.
SHOW FUNCTIONS
SHOW FUNCTIONS queries all custom or built-in functions in a database.