SHOW CREATE FUNCTION
On this page
Outputs configuration information about an existing user-defined function, including user-defined scalar value functions (UDFs) and user-defined table-valued functions (TVFs).
SHOW CREATE PROCEDURE is an alias for this command.
Syntax
SHOW CREATE FUNCTION { function_name | database_name.function_name }
Remarks
-
Refer to the Permission Matrix for the required permission.
Example
The following example demonstrates how to see the configuration of an existing UDF named plus_ while connected to the current database.
SHOW CREATE FUNCTION plus_one\G;
*** 1. row ***
Function: plus_one
Create Function: CREATE FUNCTION `plus_one`(a int(11) NULL) RETURNS int(11) NULL AS
BEGIN
RETURN a + 1;
END;
character_set_client: utf8
collation_connection: utf8_general_ci
1 row in set (0.00 sec)Related Topics
Last modified: September 6, 2023