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
-------

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/