SHOW CREATE FUNCTION func_name
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
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
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/show-create-function/