Additional languages
MySQL 5.0 Reference Manual :: 17 Stored Procedures and Functions :: 17.2 Stored Routine Syntax :: 17.2.2 ALTER PROCEDURE and ALTER FUNCTION Syntax
« 17.2.1 CREATE PROCEDURE and CREATE FUNCTION Syntax
17.2.3 DROP PROCEDURE and DROP FUNCTION Syntax »
Section Navigation      [Toggle]

17.2.2. ALTER PROCEDURE and ALTER FUNCTION Syntax

ALTER {PROCEDURE | FUNCTION} sp_name [characteristic ...]

characteristic:
    { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
  | SQL SECURITY { DEFINER | INVOKER }
  | COMMENT 'string'

This statement can be used to change the characteristics of a stored procedure or function. As of MySQL 5.0.3, you must have the ALTER ROUTINE privilege for the routine. (That privilege is granted automatically to the routine creator.) If binary logging is enabled, this statement might also require the SUPER privilege, as described in Section 17.4, “Binary Logging of Stored Routines and Triggers”.

More than one change may be specified in an ALTER PROCEDURE or ALTER FUNCTION statement.