Re: Need an SQL*Plus script to show indexes on a given table

From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1998/02/04
Message-ID: <34D89777.19EC8F4B@charlie.cns.iit.edu>#1/1

Hi ,
Here is the script to show indexes on a given table

select b.column_name, a.index_name, a.uniqueness,b.column_position from user_indexes a, user_ind_columns b
where a.index_name = b.index_name
  and a.table_name = b.table_name
and a.table_name = UPPER('&1')
ORDER BY b.column_position;

Hope this helps

AMARENDRA B NETTEM
OARCLE DBA

---

AMARENDRA B NETTEM
Oracle Certified DBA (OCP)
Whittman-Hart Inc.,
311 South Wacker Drive, Suite 3500
Chicago, IL 60606.

Residence:

---

5039 N E River Road,
Apt. 1A
NORRIDGE, IL 60656 Ph.No. (708) 583 9870 (H)

       (312) 913 6758 (W)

 E-mail:nettama_at_charlie.cns.iit.edu,

        anettem_at_whittman-hart.com

Homepage: http://www.iit.edu/~nettama

---

Opinions are mine and do not necessarily reflect those of Whittman-hart Inc. Received on Wed Feb 04 1998 - 00:00:00 CST