Retrieve the CREATE FUNCTION statement. This statement shows the exact SQL used to define a stored function, including its body and characteristics.
This statement is similar to SHOW CREATE PROCEDURE but for stored functions.
SHOW CREATE FUNCTION quotes identifiers, according to the value of the system variable.
SHOW CREATE FUNCTION quotes identifiers, according to the value of the system variable. However, the output of this statement is unreliably affected by the system variable.
This page is licensed: GPLv2, originally from
SHOW CREATE FUNCTION func_nameSHOW 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