Altering a stored procedure

Authorities and privileges

To alter a stored procedure:

1. Open the Alter Procedure window.
2. Update the properties that you want to change:
• To alter a stored procedure's general properties, specify new values on the Properties page.
• To alter a stored procedure's language options, specify new values on the Parameters page.
3. If you want to change a procedure's parameter list or parameters, click on the Parameters tab in the Alter Procedure window. You can remove a parameter, change a parameter, or move a parameter's position within the parameters list.
4. Click OK.