Re: How to find indexes of a Table?
From: Tan Tuang Cher <tantc_at_mcsb.com.sg>
Date: 1996/02/16
Message-ID: <4g0l60$8bu_at_raffles.technet.sg>#1/1
Date: 1996/02/16
Message-ID: <4g0l60$8bu_at_raffles.technet.sg>#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
To get the list of indexes and its uniqueness on a table, query the user_indexes or all_indexes dictionary tables.
The user_indexes table shows all indexes own by the user and the all_indexes table shows all indexes accessible by the user.
Tuang Cher Received on Fri Feb 16 1996 - 00:00:00 CET