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 in the Properties page.
• To alter workload manager and security properties, specify new values in the Environment page.
• To alter a stored procedure's language options, specify new values in 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 change a parameter's properties or its position within the parameters list.
4. Click OK.