Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in CA ERwin Data Modeler › Trigger Properties › DML 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 and SQL Azure constraints, defaults, and rules.