Database triggers are sometimes difficult to track down. I needed to locate a list of all of the triggers in a database to check them for performance issues, and, when I turned to the INFORMATION_SCHEMA views, discovered there is not one for triggers. Oh well, back to interrogating the system tables.

Triggers are located in the sys.triggers table, so the following query delivered the information I needed:

view plain print about
2 AS parent_object,
3 AS trigger_name,
4    c.text AS trigger_def
5FROM sys.sysobjects o
6    INNER JOIN sys.triggers t
7        ON t.parent_id =
8    INNER JOIN sys.syscomments c
9        ON = t.object_id