Triggers automatically perform SQL operations in response to INSERT, UPDATE, DELETE, or MERGE modifications of the tables on which they are defined.
- In the Navigator, right-click the database or user that contains the table for which you want to enable or disable a trigger, and click Show Tables. A list of the tables the database or user contains appears in the Object List Viewer.
- In the Object List Viewer, right-click the table for which you want to enable or disable a trigger, and click Show Triggers. Any triggers that have been defined for the table are listed in the Object List Viewer.
- In the Object List Viewer, right-click the trigger you want to enable or disable, and click Enable Trigger or Disable Trigger. The value in the Enabled column of the Object List Viewer changes to reflect the new state of the trigger.