DBA Data[Home] [Help]

VIEW: SYS.EXU8REFC

Source

View Text - Preformatted

SELECT  "OBJID","OWNER","OWNERID","TNAME","ROWNER","RTNAME","CNAME","CNO","RCNO","ACTION","ENABLED","DEFER","PROPERTY","ROBJID","ROWNERID","REFTYPE","REFCONSTR","TYPE"
        FROM    sys.exu8ref
        WHERE   (ownerid, tname) IN (
                    SELECT  ownerid, name
                    FROM    sys.exu8tabc)
View Text - HTML Formatted

SELECT "OBJID"
, "OWNER"
, "OWNERID"
, "TNAME"
, "ROWNER"
, "RTNAME"
, "CNAME"
, "CNO"
, "RCNO"
, "ACTION"
, "ENABLED"
, "DEFER"
, "PROPERTY"
, "ROBJID"
, "ROWNERID"
, "REFTYPE"
, "REFCONSTR"
, "TYPE"
FROM SYS.EXU8REF
WHERE (OWNERID
, TNAME) IN ( SELECT OWNERID
, NAME
FROM SYS.EXU8TABC)