Editing a Procedure

When you edit a procedure you can edit the code manually or perform a search and replace.

Editing a Procedure Manually

To edit a procedure manually:

On the Workspace home page, click SQL Workshop and then Object Browser.

Object Browser appears.
From the Object list, select Procedures.
From the Object Selection pane, select a procedure.

The Code view appears. Be default, you can copy the code in this view for use in other tools.
Click Edit to activate edit mode.
Click Find to perform a basic search and replace.

Note:

You can expand the Edit pane by clicking the Full Screen icon in the upper right of the pane, beneath the Create button.