Primary key & Column name [message #37428] |
Thu, 07 February 2002 03:36 |
Hao
Messages: 4 Registered: December 2000
|
Junior Member |
|
|
Hi All;
How can I find out all the columns make up the primary key for a given table?? And all the column names for a particular table?
Thanks
Hao
|
|
|
Re: Primary key & Column name [message #37429 is a reply to message #37428] |
Thu, 07 February 2002 04:41 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
1)
select column_name from all_cons_columns A,ALL_CONSTRAINTS B
where A.constraint_name=b.constraint_name and
b.table_name=upper('&tablename') AND CONSTRAINT_TYPE='P' ORDER BY POSITION
2) select column_name from all_tab_columns
where table_name=upper('&TABLENAME');
|
|
|
|