VIEW: SYS.KU$_CONSTRAINT2_VIEW

Source

View Text - Preformatted

select c.owner#, c.name, c.con#, cd.obj#, cd.cols, cd.type#,
          cd.robj#, cd.rcon#, cd.rrules, cd.match#, cd.refact,
          NVL(cd.enabled,0),
          cd.intcols, to_char(cd.mtime,'YYYY/MM/DD HH24:MI:SS'), cd.defer,
          (select value(o) from ku$_schemaobj_view o
                where o.obj_num = cd.robj#),
          cast( multiset(select * from ku$_constraint_col_view col
                        where col.con_num = c.con#
                        order by col.pos_num
                        ) as ku$_constraint_col_list_t
                ),
          cast( multiset(select * from ku$_constraint_col_view col
                        where col.con_num = cd.rcon#
                        order by col.pos_num
                        ) as ku$_constraint_col_list_t
                )
   from con$ c, cdef$ cd
   where c.con# = cd.con#
     and cd.type# = 4           -- referential constraint

View Text - HTML Formatted

SELECT C.OWNER#
, C.NAME
, C.CON#
, CD.OBJ#
, CD.COLS
, CD.TYPE#
, CD.ROBJ#
, CD.RCON#
, CD.RRULES
, CD.MATCH#
, CD.REFACT
, NVL(CD.ENABLED
, 0)
, CD.INTCOLS
, TO_CHAR(CD.MTIME
, 'YYYY/MM/DD HH24:MI:SS')
, CD.DEFER
, (SELECT VALUE(O)
FROM KU$_SCHEMAOBJ_VIEW O
WHERE O.OBJ_NUM = CD.ROBJ#)
, CAST( MULTISET(SELECT *
FROM KU$_CONSTRAINT_COL_VIEW COL
WHERE COL.CON_NUM = C.CON# ORDER BY COL.POS_NUM ) AS KU$_CONSTRAINT_COL_LIST_T )
, CAST( MULTISET(SELECT *
FROM KU$_CONSTRAINT_COL_VIEW COL
WHERE COL.CON_NUM = CD.RCON# ORDER BY COL.POS_NUM ) AS KU$_CONSTRAINT_COL_LIST_T )
FROM CON$ C
, CDEF$ CD
WHERE C.CON# = CD.CON#
AND CD.TYPE# = 4 -- REFERENTIAL CONSTRAINT