Home

	Expand Search

Transact-SQL User's Guide

Chapter 16 Triggers: Enforcing Referential Integrity

Chapter 16

Triggers: Enforcing Referential Integrity

How triggers work

Using triggers vs. integrity constraints

Creating triggers

create trigger syntax

Using triggers to maintain referential integrity

Testing data modifications against the trigger test tables

Insert trigger example

Delete trigger examples

Update trigger examples

Multirow considerations

Insert trigger example using multiple rows

Delete trigger example using multiple rows

Update trigger example using multiple rows

Conditional insert trigger example using multiple rows

Rolling back triggers

Nesting triggers

Trigger self-recursion

Rules associated with triggers

Triggers and permissions

Trigger restrictions

Implicit and explicit null values

Triggers and performance

set commands in triggers

Renaming and triggers

Trigger tips

Disabling triggers

Dropping triggers

Getting information about triggers

sp_help

sp_helptext

sp_depends