Re: List table's indexes !

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 19 Jan 2000 10:29:19 +0100
Message-ID: <86405n$27cn$1@news6.isdnet.net>

select index_name from user_indexes where table_name='YOUR TABLE'; gives you all the indexes of one of your tables.

select index_name, column_name from user_ind_columns where table_name='YOUR TABLE' order by column_position; gives you the indexes and their columns.

--
Have a nice day
Michel

Pascal-Eric Servais <servpas_at_cognicase.ca> a écrit dans le message : 862k13$p09$1_at_nnrp1.deja.com...
> Hi !
> I am a little green with Oracle DB and working on a "rush" project !
> (same as usual ;)
>
> I just can't figure out how to list all the indexes that are
> associated to an Oracle table with SQL*Plus.
> Is anybody could help about that.
>
> BTW : If you are aware of any link to good online manuals, like some
> "Getting started with Oracle", I'd appreciate very much.
>
> Thanks !
>
> Pascal-Eric.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jan 19 2000 - 03:29:19 CST