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.

• sys.trigger_event_types (Transact-SQL)

To view the dependencies of a trigger

• sys.sql_expression_dependencies (Transact-SQL)

• sys.dm_sql_referenced_entities (Transact-SQL)

• sys.dm_sql_referencing_entities (Transact-SQL)

Database-Scoped DDL Triggers

To get information about database-scoped triggers

• sys.triggers (Transact-SQL)

To get information about database events that fire triggers

• sys.trigger_events (Transact-SQL)

To view the definition of a database-scoped trigger

• sys.sql_modules (Transact-SQL)

To get information about CLR database-scoped triggers

• sys.assembly_modules (Transact-SQL)

Server-Scoped DDL Triggers

To get information about server-scoped triggers

• sys.server_triggers (Transact-SQL)

To get information about server events that fire triggers

• sys.server_trigger_events (Transact-SQL)

To view the definition of a server-scoped trigger

• sys.sql_modules (Transact-SQL)

To get information about CLR server-scoped triggers

• sys.server_assembly_modules (Transact-SQL)

See Also

Concepts

Understanding SQL Dependencies

Other Resources

DDL Triggers