(mysql.info.gz) DROP PROCEDURE

Info Catalog

(mysql.info.gz) ALTER PROCEDURE

(mysql.info.gz) Maintaining Stored Procedures

(mysql.info.gz) SHOW CREATE PROCEDURE

 
 19.1.1.3 `DROP PROCEDURE' and `DROP FUNCTION'
 .............................................
 
      DROP {PROCEDURE | FUNCTION} [IF EXISTS] SP_NAME
 
 This statement is used to drop a stored procedure or function. That is,
 the specified routine is removed from the server.  You must have the
 `ALTER ROUTINE' privilege for the routine as of MySQL 5.0.3. This
 privilege is granted automatically to the routine creator.
 
 The `IF EXISTS' clause is a MySQL extension.  It prevents an error from
 occurring if the procedure or function does not exist. A warning is
 produced that can be viewed with `SHOW WARNINGS'.
 

Info Catalog

(mysql.info.gz) ALTER PROCEDURE

(mysql.info.gz) Maintaining Stored Procedures

(mysql.info.gz) SHOW CREATE PROCEDURE