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