19.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. You must have the ALTER
ROUTINE privilege for the routine. (That privilege is
granted automatically to the routine creator.) If binary logging
is enabled, the ALTER FUNCTION statement
might also require the SUPER privilege, as
described in Section 19.4, “Binary Logging of Stored Routines and Triggers”.
More than one change may be specified in an ALTER
PROCEDURE or ALTER FUNCTION
statement.
