Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft