Deleting a Trigger

See Also

When you want to disable the actions defined in the trigger that are automatically carried out on your database immediately following the specified transactions, you can delete a trigger.

You might also want to delete any triggers that enforce referential integrity between related tables if you use database diagrams to design your database. Database diagrams use relationships instead of triggers for this purpose. Thus, if a trigger duplicates a relationship in a database diagram, you should delete either the trigger or the relationship. For information about deleting relationships, see Deleting a Relationship.

To delete a trigger

  1. In Data View, expand the Tables folder.

  2. Expand the table whose trigger you want to delete.

  3. Right-click the trigger that you want to delete and choose Delete from the shortcut menu.

  4. A message prompts you to confirm the deletion. Choose Yes.

The trigger is deleted from the database and Data View.