Mega Code Archive

 

Categories / MySQL Tutorial / Procedure Function

 

ALTER PROCEDURE and ALTER FUNCTION Syntax

This statement can be used to change the characteristics of a stored procedure or function. More than one change may be specified in an ALTER PROCEDURE or ALTER FUNCTION statement. ALTER {PROCEDURE | FUNCTION} sp_name [characteristic ...] characteristic:     { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }   | SQL SECURITY { DEFINER | INVOKER }   | COMMENT 'string'