Is there a way to display all related tables to table interested. 1

[marcq]

Hello.
I've been looking for a precise answer in different place but could not find.
Is there a method (preferably pure sql clause or with help of some graphical tool) to show me relations between tables.
To be more precise. Let's assume I have a simple database already created (to make things more difficult I didn't create it) where I don't know relations
How I can check all tables related?

 

[Dagon]

There are lots of commercial tools like Erwin that do data modelling. Oracle do a free tool, which I've used in the past and was reasonably good.

SQL Developer data Modeler

If your tables have proper primary key/foreign key relationships defined, it should be possible to upload them directly into an ERD.

For Oracle-related work, contact me through Linked-In.

 

[marcq]

Ok.
Thanks. I will study this tool mentioned.
To be quite sure.
Is it so that I can connect to my desired database using this tool - and load the tables to it and see relations?

 

[marcq]

Oh. Yes. I see now more details about the tool.
Thanks again!.