Alter/Modify Stored procedure in SQL Server

Updated on August 30, 2015     Kisan Patel

This tutorial will show you how to alter / modify a stored procedure in SQL Server?

To alter the stored procedure, right click it and select Modify that brings the stored procedure in new query window with ALTER statement.

Now, alter the stored procedure (altering means addition / deletion / modifying the parameters and its type, altering the SQL statements etc.) and press Execute icon from the toolbar or hit F5 key from the keyboard that will modify the stored procedure.