Share via


Designing DML Triggers

This section explains the factors to consider when designing a DML trigger.

Topic

Description

DML Trigger Planning Guidelines

Explains the different ways AFTER triggers and INSTEAD OF triggers can be designed.

Specifying When a DML Trigger Fires

Provides examples to illustrate the differences in firing behavior between AFTER and INSTEAD OF triggers.

DML Trigger Execution

Explains how AFTER and INSTEAD OF triggers execute once they fire.

Designing INSTEAD OF Triggers

Explains design guidelines unique to INSTEAD OF triggers.

Managing Trigger Security

Explains how trigger code can run under escalated privileges and how to mitigate this threat.