Export (0) Print
Expand All

DDL Triggers

DDL Triggers are a special kind of trigger that fire in response to Data Definition Language (DDL) statements. They can be used to perform administrative tasks in the database such as auditing and regulating database operations.

This section provides the information that is required to understand, design, and implement DDL Triggers.

Topic Description

Understanding DDL Triggers

Explains DDL Triggers, how they work, when to use them, and how they differ from regular triggers.

Designing DDL Triggers

Explains DDL trigger scope and which Transact-SQL DDL statements can raise a DDL Trigger.

Implementing DDL Triggers

Explains the steps that are required to create a DDL Trigger.

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

Community Additions

ADD
Show:
© 2014 Microsoft