Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Help maping RDB

4 views
Skip to first unread message

bayden cline

unread,
May 25, 2003, 5:37:36 PM5/25/03
to
Hello, i am trying to figure out a way to map out how the various tables in
an RDB 5.1 database are linked together, just wondering if anyone here has
any sujestions for how to do this. Thanks in advance

bayden


Jefferson Humber

unread,
May 25, 2003, 7:26:25 PM5/25/03
to
Bayden,

I use the following;

SQL> SHOW TABLE(CONSTRAINT) table_name

Do this on all your tables. From here you can see what the foreign keys
reference.

After you have worked this out, you can sketch an ERD fairly easily.

Simple yet effective,

Jeff

"bayden cline" <bay...@isys.ca> wrote in message
news:AIaAa.262748$w7k....@news04.bloor.is.net.cable.rogers.com...

John Smith

unread,
May 26, 2003, 1:00:46 PM5/26/03
to

"bayden cline" <bay...@isys.ca> wrote in message
news:AIaAa.262748$w7k....@news04.bloor.is.net.cable.rogers.com...


V3.x of ERwin (now owned by Computer Associates) could connect to RDB
and read/reverse-engineer the schema. Not sure if v4.x has Rdb as a
'native' db any longer...if not, ODBC ought to work.


0 new messages