Which table has fields
information about an index?
Is there a way to retrieve
the fields used in an index? I would think
that this would be a field
in the user_indexes table; it lists out the
table that it is associated
with (table_name), and a lot of other
information.
For instance:
CREATE INDEX LNAME ON PERSONEL(LNAME,FNAME);
I want to be able to retrieve
the "LNAME,FNAME" expression down the
road.
Ans:
Table should be
user_ind_columns