Editing a Trigger

When you edit a trigger you can edit the code manually, perform a search and replace, and compile the trigger.

Editing a Trigger Manually

To edit a trigger manually:

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

Object Browser appears.
From the Object list, select Triggers.
From the Object Selection pane, select a trigger.
Select the Code tab and then click Edit to activate manual 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.