修改、删除、重命名存储过程

存储过程的修改

ALTER PROCEDURE procedure_name

[WITH ENCRYPTION]

[WITH RECOMPILE]

AS

Sql_statement

 

删除存储过程

USE book

GO

DROP procedure p_book1