(mysql.info.gz) SHOW CREATE PROCEDURE

Info Catalog

(mysql.info.gz) DROP PROCEDURE

(mysql.info.gz) Maintaining Stored Procedures

 
 19.1.1.4 `SHOW CREATE PROCEDURE' and `SHOW CREATE FUNCTION'
 ...........................................................
 
      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.gz) DROP PROCEDURE

(mysql.info.gz) Maintaining Stored Procedures