Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Re: [kode] How to get primary key for table in Oracle?

Sep 6, 2002, 12:13 PM
kellner
Enthusiast (606 posts)
Sep 6, 2002, 12:13 PM
Views: 63957
Shortcut
Quote Reply
Re: [kode] How to get primary key for table in Oracle? In reply to
Well, the command "select constraint_name from user_constraints where table_name='TABLE_NAME' and constraint_type='P'" does return a result, but as I've said before, the column "constraint_name" does not store the column name of the table I'm interested in, and I *want* the column name.

(This is on Oracle 8.0.6)
kellner
Subject Author Views Date
Thread; hot thread How to get primary key for table in Oracle? kellner 64826 Sep 6, 2002, 7:20 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle? 		Aki 63971 Sep 6, 2002, 8:30 AM
Thread; hot thread Re: [Aki] How to get primary key for table in Oracle? 		kellner 64195 Sep 6, 2002, 8:59 AM
Post; hot thread Re: [kellner] How to get primary key for table in Oracle? 		cornball 63940 Sep 6, 2002, 9:04 AM
Post; hot thread Re: [kellner] How to get primary key for table in Oracle? 		Paul 63935 Sep 6, 2002, 9:05 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle? 		Stealth 64167 Sep 6, 2002, 9:20 AM
Thread; hot thread Re: [Stealth] How to get primary key for table in Oracle? 		kellner 64286 Sep 6, 2002, 9:43 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle? 		Stealth 64165 Sep 6, 2002, 10:06 AM
Thread; hot thread Re: [Stealth] How to get primary key for table in Oracle? 		kellner 64081 Sep 6, 2002, 10:13 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle? 		Aki 64109 Sep 6, 2002, 10:20 AM
Thread; hot thread Re: [Aki] How to get primary key for table in Oracle? 		kellner 64110 Sep 6, 2002, 10:24 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle? 		Paul 64065 Sep 6, 2002, 10:34 AM
Post; hot thread Re: [Paul] How to get primary key for table in Oracle? 		Stealth 63987 Sep 6, 2002, 11:57 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle? 		cornball 64142 Sep 6, 2002, 10:42 AM
Thread; hot thread Re: [kode] How to get primary key for table in Oracle? 		kellner 64032 Sep 6, 2002, 11:59 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle? 		cornball 64065 Sep 6, 2002, 12:05 PM
Thread; hot thread Re: [kode] How to get primary key for table in Oracle? 		kellner 63957 Sep 6, 2002, 12:13 PM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle? 		604 63957 Sep 6, 2002, 1:58 PM
Post; hot thread Re: [TheStone] How to get primary key for table in Oracle? 		beni333 63327 Jan 9, 2003, 2:44 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle? 		anup123 62903 Mar 23, 2003, 12:33 PM
Thread; hot thread How to get primary key for table in Oracle? 		sunita_gateway 61548 Mar 23, 2004, 12:58 AM
Thread; hot thread Re: [sunita_gateway] How to get primary key for table in Oracle? 		hongtao 56868 Apr 23, 2008, 11:38 AM
Post; hot thread Re: [hongtao] How to get primary key for table in Oracle? 		dan 56715 Apr 23, 2008, 3:02 PM