Previous Topic: SQL Server TriggersNext Topic: DDL Triggers


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