Friday, October 19, 2007

MySQL Alter and Drop Procedure, Function

Alter Procedure and Function
ALTER {PROCEDURE | FUNCTION}
sp_name [characteristic ...] characteristic:
{ CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
| SQL SECURITY { DEFINER | INVOKER } | COMMENT '
string


Drop Procedure and Function
DROP {PROCEDURE | FUNCTION} [IF EXISTS] sp_name

No comments: