SHOW CREATE FUNCTION func_nameThis statement is similar to SHOW CREATE PROCEDURE but for stored functions.
SHOW CREATE FUNCTION quotes identifiers, according to the value of the sql_quote_show_create system variable.
SHOW CREATE FUNCTION quotes identifiers, according to the value of the sql_quote_show_create system variable. However, the output of this statement is unreliably affected by the sql_quote_show_create system variable.
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_ciThis page is licensed: GPLv2, originally from fill_help_tables.sql