SHOW CREATE FUNCTION
You are viewing an old version of this article. View
the current version here.
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
See also:
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.