Re: Find Index definition for an Oracle table

From: Venkat kambalapally <vreddy_at_ix.netcom.com>
Date: Wed, 26 Aug 1998 23:19:20 -0400
Message-ID: <35E4D038.BD5@ix.netcom.com>

Check user_ind_columns and/or all_ind_columns

Venkat

>
> I need to know how to find an index definition for an Oracle table. I see it
> in user_indexes, but I want to know which columns it is indexing.
> Specifically, I want to know if a specific column is indexed within a table.
>
> Please respond to the email below ASAP!
>
> TIA,
>
> Tim.
> tim.bedow_at_NO_SPAMps.net
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Wed Aug 26 1998 - 22:19:20 CDT