Getting Information About DDL Triggers

The catalog views listed in this section can be used to get information about DDL Triggers.

To get information about the events or event groups on which a DDL trigger can fire.

To view the dependencies of a trigger

Database-Scoped DDL Triggers

To get information about database-scoped triggers

To get information about database events that fire triggers

To view the definition of a database-scoped trigger

To get information about CLR database-scoped triggers

Server-Scoped DDL Triggers

To get information about server-scoped triggers

To get information about server events that fire triggers

To view the definition of a server-scoped trigger

To get information about CLR server-scoped triggers

See Also

Concepts

Other Resources