Collection Contents Index SYSTABAUTH system view SYSUSERAUTH system view pdf/chap16.pdf

Reference Manual
   CHAPTER 16. System Views     

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.


Collection Contents Index SYSTABAUTH system view SYSUSERAUTH system view pdf/chap16.pdf