Re: Which cols are part of the primary key?

From: Gavin <gavin.martin_at_gmail.com>
Date: 23 Mar 2006 02:31:57 -0800
Message-ID: <1143109917.596017.182950@z34g2000cwc.googlegroups.com>

minor change in line 7 for 10gR2:
"and di.index_owner = dc.owner"

SQL> desc dba_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                                        VARCHAR2(4000)
 COLUMN_POSITION                           NOT NULL NUMBER
 COLUMN_LENGTH                             NOT NULL NUMBER
 CHAR_LENGTH                                        NUMBER
 DESCEND                                            VARCHAR2(4)

Received on Thu Mar 23 2006 - 04:31:57 CST