> SQLexec (nJDEHandle, "select * from all_indexes where trim (upper(table_name)) = 'F7611B'", "CurOracle") >>and it returned a cursor full of info (below is the display struct of CurOracle), but where do I find the names of the fields that make the index?
select a.index_name, b.* from all_indexes a, all_ind_columns b where a.index_name = b.index_name and upper(a.table_name) = 'MYTABLE'You may have to join the two views on table_name as well if you have indexes with the same name on multiple tables.