Syntax\n------\n\nSHOW CREATE PROCEDURE proc_name\n\nDescription\n-----------\n\nThis 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.\n\nBoth statements require that:\n\n you are the owner of the routine;\n you have the SHOW CREATE ROUTINE privilege (from MariaDB 11.3.0); or\n you have the SELECT privilege on the mysql.proc table.\n\nWhen none of the above statements are true, the statements display NULL for the Create Procedure or Create Function field.\n\nUsers with SELECT privileges on mysql.proc or USAGE privileges on . can view the text of routines, even when they do not have privileges for the function or procedure itself.\n\nSHOW CREATE PROCEDURE quotes identifiers, according to the value of the sql_quote_show_create system variable.\n\nSHOW CREATE PROCEDURE quotes identifiers, according to the value of the sql_quote_show_create system variable. The output of this statement is unreliably affected by the sql_quote_show_create system variable.\n\nExamples\n--------\n\nSHOW CREATE PROCEDURE test.simpleproc\\G\n*********************** 1. row ***********************\n           Procedure: simpleproc\n            sql_mode: \n    Create Procedure: CREATE PROCEDURE simpleproc(OUT param1 INT)\n                      BEGIN\n                      SELECT COUNT() INTO param1 FROM t;\n                      END\ncharacter_set_client: latin1\ncollation_connection: latin1_swedish_ci\n  Database Collation: latin1_swedish_ci\n\nSHOW CREATE FUNCTION test.hello\\G\n************************ 1. row ************************\n            Function: hello\n            sql_mode:\n     Create Function: CREATE FUNCTION hello(s CHAR(20))\n                      RETURNS CHAR(50)\n                      RETURN CONCAT('Hello, ',s,'!')\ncharacter_set_client: latin1\ncollation_connection: latin1_swedish_ci\n  Database Collation: latin1_swedish_ci\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-procedure