VIEW: SYS.KU$_CONSTRAINT_COL_VIEW

Source

View Text - Preformatted

select cc.con#, cc.obj#, cc.intcol#, cc.pos#, cc.spare1,
  decode(bitand(c.property,1024+2),0,0,2,1,1024,2,0),
  decode(bitand(c.property,2097152+1024),
         2097152,(select value(c1) from ku$_simple_pkref_col_view c1
                  where c1.obj_num    = cc.obj# and
                        c1.intcol_num = cc.intcol#),
            1024,(select value(c2) from ku$_simple_setid_col_view c2
                  where c2.obj_num    = cc.obj# and
                        c2.intcol_num = cc.intcol#),
            value(c))
  from ku$_simple_col_view c, ccol$ cc
  where c.obj_num    = cc.obj#
    and c.intcol_num = cc.intcol#

View Text - HTML Formatted

SELECT CC.CON#
, CC.OBJ#
, CC.INTCOL#
, CC.POS#
, CC.SPARE1
, DECODE(BITAND(C.PROPERTY
, 1024+2)
, 0
, 0
, 2
, 1
, 1024
, 2
, 0)
, DECODE(BITAND(C.PROPERTY
, 2097152+1024)
, 2097152
, (SELECT VALUE(C1)
FROM KU$_SIMPLE_PKREF_COL_VIEW C1
WHERE C1.OBJ_NUM = CC.OBJ# AND C1.INTCOL_NUM = CC.INTCOL#)
, 1024
, (SELECT VALUE(C2)
FROM KU$_SIMPLE_SETID_COL_VIEW C2
WHERE C2.OBJ_NUM = CC.OBJ# AND C2.INTCOL_NUM = CC.INTCOL#)
, VALUE(C))
FROM KU$_SIMPLE_COL_VIEW C
, CCOL$ CC
WHERE C.OBJ_NUM = CC.OBJ#
AND C.INTCOL_NUM = CC.INTCOL#