Re: How to find indexes of a Table?

From: Swapan Jha <sjha_at_us.oracle.com>
Date: 1996/02/15
Message-ID: <4fvs5k$i7_at_inet-nntp-gw-1.us.oracle.com>#1/1


Hi There,

     Use these tablee:  

SQL> desc user_ind_columns

 Name                            Null?    Type

------------------------------- -------- ----
INDEX_NAME NOT NULL VARCHAR2(30) TABLE_NAME NOT NULL VARCHAR2(30) COLUMN_NAME NOT NULL VARCHAR2(30) COLUMN_POSITION NOT NULL NUMBER COLUMN_LENGTH NOT NULL NUMBER SQL> desc all_ind_columns Name Null? Type
------------------------------- -------- ----
INDEX_OWNER NOT NULL VARCHAR2(30) INDEX_NAME NOT NULL VARCHAR2(30) TABLE_OWNER NOT NULL VARCHAR2(30) TABLE_NAME NOT NULL VARCHAR2(30) COLUMN_NAME NOT NULL VARCHAR2(30) COLUMN_POSITION NOT NULL NUMBER COLUMN_LENGTH NOT NULL NUMBER
  • Swapan Jha
Received on Thu Feb 15 1996 - 00:00:00 CET

Original text of this message