Re: How to find indexes of a Table?
From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1996/02/18
Message-ID: <4g6cra$d8n_at_cloner3.netcom.com>#1/1
Date: 1996/02/18
Message-ID: <4g6cra$d8n_at_cloner3.netcom.com>#1/1
In article <1996Feb13.142803.73995_at_cc.usu.edu>, 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
>
Look at the following views: user_indexes, user_ind_columns, sys.dba_indexes.
><> Chuck Hamilton <><
><> chuckh_at_ix.netcom.com <><
Received on Sun Feb 18 1996 - 00:00:00 CET