How to find the Triggers details in Database

We  can use the following query to find a list of  all the triggers along with trigger details in the specific database:

select

"Table"=P.Name,

"Trigger Name"=O.name,

"Trigger Date"=O.refdate,

"Defn"=CASE C.encrypted WHEN 0 THEN C.text ELSE '<< ENCRYPTED >>' END

from

syscomments C

INNER JOIN sysobjects O ON (C.id = O.id)

INNER JOIN sysobjects P ON (O.parent_obj = P.id)

where

O.xtype = 'TR'