DML Triggers

A DML trigger is an action programmed to execute when a data manipulation language (DML) event occurs in the database server. DML events include UPDATE, INSERT, or DELETE statements issued against a table or view. DML triggers are used to enforce business rules when data is modified and to extend the integrity checking logic of Microsoft SQL Server constraints, defaults, and rules.

The topics in this section provide the information necessary to understand, design, and implement DML triggers.

In This Section

• Understanding DML Triggers
  Explains DML trigger concepts and includes descriptions and examples of when to implement DML triggers.

• Designing DML Triggers
  Provides specific guidelines, rules, and restrictions you should consider when designing a DML trigger.

• Implementing DML Triggers
  Describes the procedures to create, modify, or delete a DML trigger.