Re: How to query the definition of an index (referring to columns) with SQL ?

>Subject: How to query the definition of an index (referring to columns) with
>SQL ?
>From: Rainer.Hutz_at_t-online.de (Loy & Hutz oHG)
>Date: 2/6/98 3:30PM GMT
>Message-id: <6bfaap$35l$1_at_news00.btx.dtag.de>
>
>How can I ask Oracle with SQL, which columns are used for an index
>definition ?
>
>* ->>>Answer please to SvenKunze_at_AOL.com<<<-
>
>--
>Loy & Hutz oHG, Freiburg, Germany
>via t-online and Internet Explorer
>
>
>
>
>
>
>

The view all_ind_columns gives details of the columns used to define indexes and the order in which they are combined to form the index HTH
 Rob Received on Mon Feb 09 1998 - 00:00:00 CST