Re: How to find all index related to a table?

On Thu, 6 Jan 2000 16:59:59 +0800, "Jeff" <kit_at_cintec.cuhk.edu.hk> wrote:

>Hi,
>
>How can you retreive the index list and their details related to a table
>specified?
>
>Thanks.
>
>Jeff
>
>

select table_name, index_name, column_name from user_ind_columns
where table_name = '&tab'
order by index_name, column_position
/

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Jan 06 2000 - 03:13:55 CST