Gossamer Forum
Home : General : Databases and SQL :

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

Quote Reply
Re: [kellner] How to get primary key for table in Oracle? In reply to
One suggestion...use a GUI tool, like Toad, which will allow you to see table configurations, including sequences, triggers, constraints, etc.

You can purchase Toad from Quest Software. It's a great program.

Alternatively, you could purchase ERWIN or ERStudio to reverse engineer your database and view its schema, including PK, FK, constraints, etc.
========================================
Buh Bye!

Cheers,
Me
Subject Author Views Date
Thread; hot thread How to get primary key for table in Oracle? kellner 64077 Sep 6, 2002, 7:20 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
Aki 63236 Sep 6, 2002, 8:30 AM
Thread; hot thread Re: [Aki] How to get primary key for table in Oracle?
kellner 63456 Sep 6, 2002, 8:59 AM
Post; hot thread Re: [kellner] How to get primary key for table in Oracle?
cornball 63202 Sep 6, 2002, 9:04 AM
Post; hot thread Re: [kellner] How to get primary key for table in Oracle?
Paul 63200 Sep 6, 2002, 9:05 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
Stealth 63425 Sep 6, 2002, 9:20 AM
Thread; hot thread Re: [Stealth] How to get primary key for table in Oracle?
kellner 63541 Sep 6, 2002, 9:43 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
Stealth 63422 Sep 6, 2002, 10:06 AM
Thread; hot thread Re: [Stealth] How to get primary key for table in Oracle?
kellner 63336 Sep 6, 2002, 10:13 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
Aki 63367 Sep 6, 2002, 10:20 AM
Thread; hot thread Re: [Aki] How to get primary key for table in Oracle?
kellner 63370 Sep 6, 2002, 10:24 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
Paul 63326 Sep 6, 2002, 10:34 AM
Post; hot thread Re: [Paul] How to get primary key for table in Oracle?
Stealth 63249 Sep 6, 2002, 11:57 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
cornball 63405 Sep 6, 2002, 10:42 AM
Thread; hot thread Re: [kode] How to get primary key for table in Oracle?
kellner 63297 Sep 6, 2002, 11:59 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
cornball 63327 Sep 6, 2002, 12:05 PM
Thread; hot thread Re: [kode] How to get primary key for table in Oracle?
kellner 63221 Sep 6, 2002, 12:13 PM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
604 63219 Sep 6, 2002, 1:58 PM
Post; hot thread Re: [TheStone] How to get primary key for table in Oracle?
beni333 62592 Jan 9, 2003, 2:44 AM
Thread; hot thread Re: [kellner] How to get primary key for table in Oracle?
anup123 62167 Mar 23, 2003, 12:33 PM
Thread; hot thread How to get primary key for table in Oracle?
sunita_gateway 60802 Mar 23, 2004, 12:58 AM
Thread; hot thread Re: [sunita_gateway] How to get primary key for table in Oracle?
hongtao 56133 Apr 23, 2008, 11:38 AM
Post; hot thread Re: [hongtao] How to get primary key for table in Oracle?
dan 55974 Apr 23, 2008, 3:02 PM