Gossamer Forum
Home : General : Databases and SQL :

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

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 64076 Sep 6, 2002, 7:20 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
Aki 63235 Sep 6, 2002, 8:30 AM
Thread; hot thread Re: [Aki] How to get primary key for table in Oracle?
kellner 63455 Sep 6, 2002, 8:59 AM
Post; hot thread Re: [kellner] How to get primary key for table in Oracle?
cornball 63201 Sep 6, 2002, 9:04 AM
Post; hot thread Re: [kellner] How to get primary key for table in Oracle?
Paul 63199 Sep 6, 2002, 9:05 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
Stealth 63423 Sep 6, 2002, 9:20 AM
Thread; hot thread Re: [Stealth] How to get primary key for table in Oracle?
kellner 63540 Sep 6, 2002, 9:43 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
Stealth 63421 Sep 6, 2002, 10:06 AM
Thread; hot thread Re: [Stealth] How to get primary key for table in Oracle?
kellner 63335 Sep 6, 2002, 10:13 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
Aki 63366 Sep 6, 2002, 10:20 AM
Thread; hot thread Re: [Aki] How to get primary key for table in Oracle?
kellner 63369 Sep 6, 2002, 10:24 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
Paul 63325 Sep 6, 2002, 10:34 AM
Post; hot thread Re: [Paul] How to get primary key for table in Oracle?
Stealth 63248 Sep 6, 2002, 11:57 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
cornball 63404 Sep 6, 2002, 10:42 AM
Thread; hot thread Re: [kode] How to get primary key for table in Oracle?
kellner 63296 Sep 6, 2002, 11:59 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
cornball 63326 Sep 6, 2002, 12:05 PM
Thread; hot thread Re: [kode] How to get primary key for table in Oracle?
kellner 63220 Sep 6, 2002, 12:13 PM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
604 63218 Sep 6, 2002, 1:58 PM
Post; hot thread Re: [TheStone] How to get primary key for table in Oracle?
beni333 62591 Jan 9, 2003, 2:44 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
anup123 62166 Mar 23, 2003, 12:33 PM
Thread; hot thread How to get primary key for table in Oracle?
sunita_gateway 60801 Mar 23, 2004, 12:58 AM
Thread; hot thread Re: [sunita_gateway] How to get primary key for table in Oracle?
hongtao 56132 Apr 23, 2008, 11:38 AM
Post; hot thread Re: [hongtao] How to get primary key for table in Oracle?
dan 55973 Apr 23, 2008, 3:02 PM