- In the Navigator, expand Databases, right-click the database or user that contains the table for which you want to modify a trigger, and click Show Tables.
-
In the Object List Viewer:
- Right-click the table for which you want to modify a trigger, and click Show Triggers.
- Right-click the trigger you want to modify, and click Modify Trigger.
- Modify properties by entering new information into the property fields.
- [Optional] Click the SQL tab to see the SQL code that will be executed on the connected system to modify the trigger.
-
Click Commit.
If an error is returned, modify your trigger properties to address the error.
- Click OK.