VIEW: SYS.KU$_INDEXOP_VIEW

Source

View Text - Preformatted

select io.obj#, io.oper#, io.bind#, io.property,
         (select value(o) from sys.ku$_schemaobj_view o
          where io.oper#=o.obj_num),
         cast(multiset(select * from sys.oparg$ oa
                       where oa.obj#=io.oper# and oa.bind#=io.bind#
                       order by oa.position
                      ) as ku$_oparg_list_t
             )
  from sys.indop$ io

View Text - HTML Formatted

SELECT IO.OBJ#
, IO.OPER#
, IO.BIND#
, IO.PROPERTY
, (SELECT VALUE(O)
FROM SYS.KU$_SCHEMAOBJ_VIEW O
WHERE IO.OPER#=O.OBJ_NUM)
, CAST(MULTISET(SELECT *
FROM SYS.OPARG$ OA
WHERE OA.OBJ#=IO.OPER#
AND OA.BIND#=IO.BIND# ORDER BY OA.POSITION ) AS KU$_OPARG_LIST_T )
FROM SYS.INDOP$ IO