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 2005 constraints, defaults, and rules.

This section provides the information necessary to understand, design, and implement DML triggers.

Topic Description

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.