ERD tool that can reverse engineer using Levels of Foreign Keys away from root table
Reverse engineering a 10 year old datamodel with 600 tables results in a messy circuit diagram.
What I really need is to choose a source table central to the main themes such as ORDER_LINE_ITEM and then have the ERD tool pull in tables to the diagram that are 1,2,3 foreign key relations away.
I once used a tool that would let me 'throttle' the size of tables involved like this but it was for MS_SQL.
Does such a tool exist ?
ER/Studio seemed to have that 'LEVEL' facility for child or parent Fkey releated entities in a Subdatamodel but it never actually added them in automatically.
SQL Developer from Oracle is like the sqlplus command history with a depth of '1'. You can auto pull in children or parents but only one ring or level away from the table your working with.
Click Here to Expand Forum to Full Width