See what PC Week thinks the best SQL integrated development environment
is:
http://www.zdnet.com/pcweek/stories/news/0,4153,363685,00.html
> -----Original Message-----
> From: oliver.willandsen_at_sg.cec.be [SMTP:oliver.willandsen_at_sg.cec.be]
> Posted At: Friday, October 30, 1998 6:11 AM
> Posted To: server
> Conversation: Making an ERD from an existing db
> Subject: Re: Making an ERD from an existing db
>
> In article <robertdg-2910981126310001_at_robertsd-mac.hpw.pri.bms.com>,
> robertdg_at_bms.com (Dan Roberts) wrote:
> > Hello All
> >
> > I have an existing Oracle rdbms for which I would like to draw up an
> ERD.
> > How can I get PK and FK information from the DB in the process of
> > determining the realtionships btw the tables as I do a desc on each
> > table??
> >
> > Thanks!!.Dan
> >
> > --
> > NOTE:REMOVE THE *.* in my address for direct replies
> > Dan Roberts
> > BRISTOL-MYERS SQUIBB PHARM. RES. CENTER "Nature is last at
> Bats"
> > PRINCETON, NEW JERSEY U.S.A. PLANET EARTH, MILKY-WAY GALAXY
> > <<<<INTERNET ADDRESS>>>>Roberts_Daniel_G.PriLVMS4_at_MSMAIL.BMS.COM
> >
> >
>
> Hi Dan, if you don't want to use a full-blown design tool such as
> Powerdesigner etc. to do your reverse-engineering and diagram-drawing
> automatically, have a look at T.O.A.D from www.toadsoft.com. This
> freeware
> tool lets you browse your Oracle database, showing you virtually every
> possible object, including FKs, PKs, procedures, triggers etc. - it's
> invaluable.
>
> Regards
>
> --
> Oliver Willandsen
> European Commission
> http://europa.eu.int
>
> All comments represent my own opinion and may not in any circumstance
> be regarded as stating an official position of the European Commission
>
> -----------== Posted via Deja News, The Discussion Network
> ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your
> Own
Received on Fri Oct 30 1998 - 17:34:54 CST
