This discussion is archived
6 Replies Latest reply: Dec 19, 2013 3:36 AM by 3fac695d-54e8-4d64-8aae-f6eb189adeea RSS

Generate ER Diagram from Sql Data Modeler

3fac695d-54e8-4d64-8aae-f6eb189adeea Newbie
Currently Being Moderated



I want to use the Oracle Sql Developer Data Modeler to generate ER diagram for my schema. There are huge number of tables in this schema, so I would like to identify only those tables which need to be selected for generating my ER diagram.


Basically, I want only those table which are having relationship with other tables here. The reason being, if I select all tables in the schema then I would get those tables in the ER diagram which don't have any relationship with other tables.


Can someone please suggest writing queries which yield this from data dictionary?




  • Correct Answers - 10 points
  • Helpful Answers - 5 points