SELECT
    T.[name] AS Trigger_Name,
    OBJECT_NAME(T.parent_id) AS Table_Name,
    TE.type_desc,
    T.create_date
FROM
    sys.triggers T
    JOIN
    sys.trigger_events TE ON T.[object_id] = TE.[object_id];