第1个回答 2010-11-27
ALTER PROCEDURE proc_name [characteristic ...]
characteristic:
| SQL SECURITY
| COMMENT 'string'
This statement can be used to change the characteristics of a stored procedure. More than one change may be specified in an ALTER PROCEDURE statement. However, you cannot change the parameters or body of a stored procedure using this statement; to make such changes, you must drop and re-create the procedure using DROP PROCEDURE and CREATE PROCEDURE.
就是说只能改名字和定义不能改里面的内容。要删了重新建。本回答被提问者采纳