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 - 05:11:28 CST