SQL-Server Triggers  «Prev  Next»

Lesson 9 Deleting triggers
Objective 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:
  1. Right-click the name of the table that the trigger is assigned to.
  2. Choose the All Tasks | Manage Triggers menu option, and select your trigger from the drop-down list.
  3. Click the Delete button to delete your trigger.

Using Transact-SQL

To delete a trigger with Transact-SQL, you will use the DROP TRIGGER statement, as shown below:

Using the DROP TRIGGER statement

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.