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
 
Hosted by www.Geocities.ws

1