Reference Manual
CHAPTER 16. System Views
CREATE VIEW SYS.SYSTRIGGERS ( owner, trigname, tname, event, trigtime, trigdefn ) AS SELECT ( SELECT user_name FROM SYS.SYSUSERPERM WHERE user_id = SYSTABLE.creator ), trigger_name, table_name, IF event = 'I' THEN 'INSERT' ELSE IF event = 'U' THEN 'UPDATE' ELSE IF event = 'C' THEN 'UPDATE' ELSE 'DELETE' ENDIF ENDIF ENDIF, IF trigger_time = 'B' THEN 'BEFORE' ELSE 'AFTER' ENDIF, trigger_defn FROM SYS.SYSTRIGGER == SYS.SYSTABLE WHERE foreign_table_id IS NULL
Lists all the triggers from SYSTRIGGER in a readable format.