| Lesson 9
| Deleting triggers
| Practice deleting triggers.
Using Enterprise Manager
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.
To delete a trigger with Transact-SQL, you will use the
DROP TRIGGER statement, as shown below:
To delete a trigger named
trgSalary, simply execute this Transact-SQL statement:
DROP TRIGGER trgSalary
In the next lesson, you will learn how to test triggers.