SQL Server > Stored Procedure

Alter / Modify a stored procedure in SQL Server

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.