Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how do I find out column name on which a index is build

Re: how do I find out column name on which a index is build

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 10 Jan 2001 00:20:49 +0100
Message-ID: <93i97q$ahcqs$2@ID-62141.news.dfncis.de> 






select table_name, index_name, column_name
from user_ind_columns


order by table_name, index_name, column_position



Regards,



Sybrand Bakker, oracle DBA



<shdu_at_my-deja.com> wrote in message news:93g4kv$eu3$1_at_nnrp1.deja.com...


> how do I find out column name on which a index is build

> Thanks

>

> SF

>

>

> Sent via Deja.com

> http://www.deja.com/

Received on Tue Jan 09 2001 - 17:20:49 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US