Re: What Indexes do I have???

From: <denny_vk_at_hotmail.com>
Date: 1998/02/25
Message-ID: <6d2lq2$gc7$1@nnrp1.dejanews.com>#1/1

In article <6csisi$sdm_at_clarknet.clark.net>, 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.
>

You can query USER_INDEXES or ALL_INDEXES or DBA_INDEXES to find the tablename and indexes on the tables. To find the column names for each index use USER_IND_COLUMNS or ALL_IND_COLUMNS or DBA_IND_COLUMNS.

Denny

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Feb 25 1998 - 00:00:00 CST