Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Find Index definition for an Oracle table

Re: Find Index definition for an Oracle table

From: Srinivas Chikka <SCHIKKA_at_worldnet.att.net>
Date: 27 Aug 1998 23:01:33 GMT
Message-ID: <6s4ogd$ri3@bgtnsc01.worldnet.att.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US