VIEW: SYS.KU$_TRIGGERCOL_VIEW

Source

View Text - Preformatted

select '1','0',
         tc.obj#, tc.col#, tc.type#, tc.position#, tc.intcol#, c.name,
         (select a.name from attrcol$ a where
                        a.obj#=tc.obj# and a.intcol#=tc.intcol#)
  from col$ c, triggercol$ tc, trigger$ t
  where tc.obj#=t.obj#
    and c.obj#=t.baseobject
    and c.intcol#=tc.intcol#

View Text - HTML Formatted

SELECT '1'
, '0'
, TC.OBJ#
, TC.COL#
, TC.TYPE#
, TC.POSITION#
, TC.INTCOL#
, C.NAME
, (SELECT A.NAME
FROM ATTRCOL$ A WHERE A.OBJ#=TC.OBJ#
AND A.INTCOL#=TC.INTCOL#)
FROM COL$ C
, TRIGGERCOL$ TC
, TRIGGER$ T
WHERE TC.OBJ#=T.OBJ#
AND C.OBJ#=T.BASEOBJECT
AND C.INTCOL#=TC.INTCOL#