VIEW: SYS.KU$_CLSTCOL_VIEW

Source

View Text - Preformatted

select k.clstobj#, k.tabobj#, value(o),
         k.position, k.groupid, c.col#, c.intcol#, c.segcol#,
         bitand(c.property, 4294967295),
         trunc(c.property / power(2,32)),
         c.name, c.type#
    from ku$_schemaobj_view o, col$ c, clstkey$ k
    where k.tabobj#=o.obj_num
      and c.obj#=k.tabobj#
      and c.intcol#=k.intcol#

View Text - HTML Formatted

SELECT K.CLSTOBJ#
, K.TABOBJ#
, VALUE(O)
, K.POSITION
, K.GROUPID
, C.COL#
, C.INTCOL#
, C.SEGCOL#
, BITAND(C.PROPERTY
, 4294967295)
, TRUNC(C.PROPERTY / POWER(2
, 32))
, C.NAME
, C.TYPE#
FROM KU$_SCHEMAOBJ_VIEW O
, COL$ C
, CLSTKEY$ K
WHERE K.TABOBJ#=O.OBJ_NUM
AND C.OBJ#=K.TABOBJ#
AND C.INTCOL#=K.INTCOL#