Syntax
------ 
SHOW CREATE FUNCTION func_name
 
Description
----------- 
This statement is similar to 
SHOW CREATE PROCEDURE but for
stored functions.
 
The output of this statement is unreliably affected by the
sql_quote_show_create server system variable - see
http://bugs.mysql.com/bug.php?id=12719
 
Example
 
MariaDB [test]> SHOW CREATE FUNCTION VatCents\G
*************************** 1. row
***************************
 Function: VatCents
 sql_mode: 
 Create Function: CREATE DEFINER=`root`@`localhost` FUNCTION
`VatCents`(price DECIMAL(10,2)) RETURNS int(11)
 DETERMINISTIC
BEGIN
 DECLARE x INT;
 SET x = price * 114;
 RETURN x;
END
character_set_client: utf8
collation_connection: utf8_general_ci
 Database Collation: latin1_swedish_ci
 


URL: https://mariadb.com/kb/en/show-create-function/