SHOW CREATE PROCEDURE
You are viewing an old version of this article. View
the current version here.
Syntax
SHOW CREATE PROCEDURE proc_name
Contents
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 are the owner of the routine or have the SELECT
privilege on the mysql.prc
table. When neither is true, the statements display NULL
for the Create Procedure
or Create Function
field.
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
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.