Re: What Indexes do I have???

From: LARRY E RUENACHT <RUFEN_at_prodigy.net>
Date: 1998/02/24
Message-ID: <01bd40df$fd6b6340$2e2273cf@default>#1/1

Besides the view ALL_INDEXES, query the dictionary view ALL_IND_INDEXES to ascertain the columns used in the index..

Gabriel B. Gonzalez <gabriel_at_uci.edu> wrote in article <34f17fa2.28493631_at_news2.ibm.net>...
> On 23 Feb 1998 19:32:34 GMT, cnelson_at_127.0.0.1 (Craig Nelson) wrote:
>
> >Anyone know how to list the names and other attributes of Indexes inside
a
> >table? I know I can DROP INDEX Mytable.mycolumn_index, and it works
great
> >if you know the name.
>
> try running a query on ALL_INDEXES. It is an alias for a data
> dictionary table.
>
> gg
>
Received on Tue Feb 24 1998 - 00:00:00 CST