Sybase Adaptive Server Anywhere - SYSTRIGGERS System View

Chapter 16 System Views
1071
SYSTRIGGERS system view
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.