Finding interrelation between primary keys in tables

28 Dec 2006 8:57 AM

hirak chatterjee

Hi,
i want to find interrelations among all the primary keys in all the
tables.
for e.g== the output will be
.....is the primary key of table............
.....is the primary key of table..... and foreign key in table......
etc...like this.
i am using jdbc and oracle.
i will take care of the exact format of the output,but someone please
help me in wrting queries that will give me exactly the results i stated
above.
it is urgent please help............

*** Sent via Developersdex http://www.developersdex.com ***

28 Dec 2006 6:13 PM

RobinS

You might want to post this to an Oracle newsgroup
or a Java newsgroup (since you're using jdbc).
This is a VB.net programming newsgroup.

Robin S.
-----------------------------------
Show quoteHide quote

"hirak chatterjee" <hirak1***@gmail.com> wrote in message
news:%23XnJ74lKHHA.3668@TK2MSFTNGP02.phx.gbl...
>
>
> Hi,
> i want to find interrelations among all the primary keys in all the
> tables.
> for e.g== the output will be
> ....is the primary key of table............
> ....is the primary key of table..... and foreign key in table......
> etc...like this.
> i am using jdbc and oracle.
> i will take care of the exact format of the output,but someone please
> help me in wrting queries that will give me exactly the results i
> stated
> above.
> it is urgent please help............
>
> *** Sent via Developersdex http://www.developersdex.com ***