(mysql.info) show-create-procedure

 
 13.5.4.5 `SHOW CREATE PROCEDURE' and `SHOW CREATE FUNCTION' Syntax
 ..................................................................
 
      SHOW CREATE {PROCEDURE | FUNCTION} SP_NAME
 
 This statement is a MySQL extension. Similar to `SHOW CREATE TABLE', it
 returns the exact string that can be used to re-create the named
 routine.
 
      mysql> SHOW CREATE FUNCTION test.hello\G
      *************************** 1. row ***************************
             Function: hello
             sql_mode:
      Create Function: CREATE FUNCTION `test`.`hello`(s CHAR(20)) RETURNS CHAR(50)
      RETURN CONCAT('Hello, ',s,'!')

Info Catalog

(mysql.info) show-create-database

(mysql.info) show

(mysql.info) show-create-table

automatically generated byinfo2html