How to: Delete a Trigger
You can delete triggers that are no longer necessary or cause unwanted actions on your database. For example, if you use Table Designer to design your tables, referential integrity is enforced using relationships instead of triggers. If a trigger duplicates a relationship in Table Designer, you may want to delete either the trigger or the relationship. For information about deleting relationships, see How to: Delete Relationships.
Note
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.
To delete a trigger
In Server Explorer, expand the Tables folder.
Expand the table with the trigger you want to delete.
Right-click the trigger that you want to delete and choose Delete on the shortcut menu.
A message prompts you to confirm the deletion. Choose Yes.
The trigger is deleted from the database and Server Explorer.