Re: How to find indexes of a Table?

From: (wrong string) ît Stephenson <Benoit.Stephenson_at_dmr.ca>
Date: 1996/02/19
Message-ID: <4ga9gb$koo_at_wagner.spc.videotron.ca>#1/1

sl6gs_at_cc.usu.edu wrote:

>Hi Everyone:
 

> I created several tables and added
>indexes to each tables. I could not
>remember how many indexes related
>to each individual table. are there
>any way that I can find the name of
>indexes correpond to a individual table?
>Say, find all the indexs with patient table?

> Any help from your experienced programmer
>will be greatly paareciated.

>Wei Jiang

You have to query the table all_indexes, or user_indexes or also all_ind_columns:

---

SPOOL INDEX.LIS

select table_owner     table_owner,
       table_name      table_name,
       index_name      index_name,
       column_name     column_name,
       column_position column_position

from all_ind_columns
where table_owner = YOUR_USERNAME
order

by     table_name,
        index_name,
       column_position;

spool off;

---

you can add another where clause to get the indexes of a specific table....

Benoit Stephenson

---

Benoit.Stephenson_at_dmr.ca Received on Mon Feb 19 1996 - 00:00:00 CET