Getting Information About DDL Triggers

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

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

To get information about server events that fire triggers

• sys.server_trigger_events

To view the definition of a server-scoped trigger

• sys.server_sql_modules

To get information about CLR server-scoped triggers

• sys.server_assembly_modules (Transact-SQL)

See Also

Other Resources

DDL Triggers

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
12 December 2006	Changed content: To view the definition of a server-scoped trigger, use the sys.server_sql_modules catalog view.