Re: How to find primary key from a table?

In article <1995May16.123345.25769_at_sfc.keio.ac.jp>, Yoshiaki Araki (t93827ya_at_sfc.keio.ac.jp) writes:
>
>I have no idea which column is a primary key.
>Does anyone knows how to find a primary key from a table?
>Thanks in advances.
>
>yoshiaki araki
>t93827ya_at_sfc.keio.ac.jp

Greetings Yoshiaki,

 Try DBA_CONSTRAINTS and DBA_CONS_COLUMNS views.

 Regards,
 Alex Long

--
                          ,     \    /      ,
                         / \    )\__/(     / \   
                        /   \  (_\  /_)   /   \                
 ______________________/_____\__\_at_  @/___/_____\________________ 
|paladin.along.dialix.oz.au 					|
|Alex Long 		   					|		
|Adelaide, South Australia 					|
|_______________________________________________________________|
|Weep not for little Leonie,                   			|
|Abducted by a French Marquis!               			|
|Though loss of honour was a wrench,           			|
|Just think how it's improved her French.         Harry Graham. |
+_______________________________________________________________+
                   |    /\ /      \\       \ /\    |             
                   |  /   V        ))       V   \  |
                   |/     `       //        '     \|
                   `              V                '
                   
_