VIEW: SYS.KU$_REF_CONSTRAINT_VIEW

Source

View Text - Preformatted

select '1', '1',
         c.con#,
         u.name,
         c.name, cd.defer, cd.obj#,
         (select value(sov) from ku$_schemaobj_view sov
          where sov.obj_num=cd.obj#),
         value(con)
  from  obj$ o, con$ c, cdef$ cd, user$ u,
        ku$_constraint2_view con
  where cd.obj# = o.obj# and
        c.con# = cd.con# and
        u.user# = c.owner# and
        con.con_num = c.con# and
        (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (u.user#, 0)
        OR EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '1'
, C.CON#
, U.NAME
, C.NAME
, CD.DEFER
, CD.OBJ#
, (SELECT VALUE(SOV)
FROM KU$_SCHEMAOBJ_VIEW SOV
WHERE SOV.OBJ_NUM=CD.OBJ#)
, VALUE(CON)
FROM OBJ$ O
, CON$ C
, CDEF$ CD
, USER$ U
, KU$_CONSTRAINT2_VIEW CON
WHERE CD.OBJ# = O.OBJ# AND C.CON# = CD.CON# AND U.USER# = C.OWNER# AND CON.CON_NUM = C.CON# AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (U.USER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))