Re: Find Index definition for an Oracle table

select column_name from user_ind_columns where index_name = 'your_index_name_in_uppercase';

or

select column_name from user_ind_columns where table_name = 'your_table_name_in_uppercase';

>I need to know how to find an index definition for an Oracle table. I see
it
>in user_indexes, but I want to know which columns it is indexing.
>Specifically, I want to know if a specific column is indexed within a
table.

Hope it helps.
Srinivas.Chikka Received on Thu Aug 27 1998 - 18:01:33 CDT