VIEW: SYS.EXU7INDI

Source

View Text - Preformatted

SELECT "IOBJID","INAME","IOWNER","IOWNERID","ISPACE","IFILENO","IBLOCKNO","BTNAME","BTOBJID","BTOWNER","BTOWNERID","UNIQUE$","CLUSTER$","PCTFREE$","INITRANS","MAXTRANS","BLEVEL","BITMAP","REVERSE" from sys.exu7ind
       WHERE (iownerid, btname) in
        ((SELECT ownerid, name from sys.exu7tabi)
        UNION
            (SELECT r.ownerid, r.tname
                FROM sys.exu7tabi ii ,sys.exu7ref r
                WHERE r.rtname= ii.name ))

View Text - HTML Formatted

SELECT "IOBJID"
, "INAME"
, "IOWNER"
, "IOWNERID"
, "ISPACE"
, "IFILENO"
, "IBLOCKNO"
, "BTNAME"
, "BTOBJID"
, "BTOWNER"
, "BTOWNERID"
, "UNIQUE$"
, "CLUSTER$"
, "PCTFREE$"
, "INITRANS"
, "MAXTRANS"
, "BLEVEL"
, "BITMAP"
, "REVERSE"
FROM SYS.EXU7IND
WHERE (IOWNERID
, BTNAME) IN ((SELECT OWNERID
, NAME
FROM SYS.EXU7TABI) UNION (SELECT R.OWNERID
, R.TNAME
FROM SYS.EXU7TABI II
, SYS.EXU7REF R
WHERE R.RTNAME= II.NAME ))