There may come a time when the business rule defined by the trigger is no longer in place. Therefore, to stop enforcement of the rules, you must delete the trigger.
To use Enterprise Manager:
- Right-click the name of the table that the trigger is assigned to.
- Choose the All Tasks | Manage Triggers menu option, and select your trigger from the drop-down list.
- Click the Delete button to delete your trigger.