Gossamer Forum: General: Databases and SQL: Re: [sunita_gateway] How to get primary key for table in Oracle? (hongtao)

try this:

select dbms_metadata.get_ddl('TABLE', '$TABLE', '$THEME') from dual;

this will display the command used to create the table and it should contain the primary key you are looking for.

Subject	Author	Views	Date
How to get primary key for table in Oracle?	kellner	64721	Sep 6, 2002, 7:20 AM

Re: [kellner] How to get primary key for table in Oracle?	Aki	63870	Sep 6, 2002, 8:30 AM

Re: [Aki] How to get primary key for table in Oracle?	kellner	64092	Sep 6, 2002, 8:59 AM

Re: [kellner] How to get primary key for table in Oracle?	cornball	63840	Sep 6, 2002, 9:04 AM

Re: [kellner] How to get primary key for table in Oracle?	Paul	63834	Sep 6, 2002, 9:05 AM

Re: [kellner] How to get primary key for table in Oracle?	Stealth	64060	Sep 6, 2002, 9:20 AM

Re: [Stealth] How to get primary key for table in Oracle?	kellner	64175	Sep 6, 2002, 9:43 AM

Re: [kellner] How to get primary key for table in Oracle?	Stealth	64059	Sep 6, 2002, 10:06 AM

Re: [Stealth] How to get primary key for table in Oracle?	kellner	63970	Sep 6, 2002, 10:13 AM

Re: [kellner] How to get primary key for table in Oracle?	Aki	64005	Sep 6, 2002, 10:20 AM

Re: [Aki] How to get primary key for table in Oracle?	kellner	64006	Sep 6, 2002, 10:24 AM

Re: [kellner] How to get primary key for table in Oracle?	Paul	63963	Sep 6, 2002, 10:34 AM

Re: [Paul] How to get primary key for table in Oracle?	Stealth	63888	Sep 6, 2002, 11:57 AM

Re: [kellner] How to get primary key for table in Oracle?	cornball	64038	Sep 6, 2002, 10:42 AM

Re: [kode] How to get primary key for table in Oracle?	kellner	63930	Sep 6, 2002, 11:59 AM

Re: [kellner] How to get primary key for table in Oracle?	cornball	63961	Sep 6, 2002, 12:05 PM

Re: [kode] How to get primary key for table in Oracle?	kellner	63854	Sep 6, 2002, 12:13 PM

Re: [kellner] How to get primary key for table in Oracle?	604	63854	Sep 6, 2002, 1:58 PM

Re: [TheStone] How to get primary key for table in Oracle?	beni333	63226	Jan 9, 2003, 2:44 AM

Re: [kellner] How to get primary key for table in Oracle?	anup123	62801	Mar 23, 2003, 12:33 PM

How to get primary key for table in Oracle?	sunita_gateway	61446	Mar 23, 2004, 12:58 AM

Re: [sunita_gateway] How to get primary key for table in Oracle?	hongtao	56768	Apr 23, 2008, 11:38 AM

Re: [hongtao] How to get primary key for table in Oracle?	dan	56616	Apr 23, 2008, 3:02 PM

Subject

Author

Views

Date