SHOW CREATE PROCEDURE
Syntax
SHOW CREATE PROCEDURE proc_name
Description
This statement is a MariaDB extension. It returns the exact string that
can be used to re-create the named stored procedure, as well as the SQL_MODE
that was used when the trigger has been created and the character set used by the connection.. A similar
statement, SHOW CREATE FUNCTION
,
displays information about stored functions.
Both statements require that you be the owner of the routine or have
SELECT
access to the mysql.proc
table. If you do
not have privileges for the routine itself, the value displayed for the Create
Procedure
or Create Function
field will be NULL
.
The output of these statements is unreliably affected by the sql_quote_show_create
server system variable - see http://bugs.mysql.com/bug.php?id=12719
Examples
SHOW CREATE PROCEDURE test.simpleproc\G *************************** 1. row *************************** Procedure: simpleproc sql_mode: Create Procedure: CREATE PROCEDURE `simpleproc`(OUT param1 INT) BEGIN SELECT COUNT(*) INTO param1 FROM t; END character_set_client: latin1 collation_connection: latin1_swedish_ci Database Collation: latin1_swedish_ci SHOW CREATE FUNCTION test.hello\G *************************** 1. row *************************** Function: hello sql_mode: Create Function: CREATE FUNCTION `hello`(s CHAR(20)) RETURNS CHAR(50) RETURN CONCAT('Hello, ',s,'!') character_set_client: latin1 collation_connection: latin1_swedish_ci Database Collation: latin1_swedish_ci