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.