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
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