Return
-
Title
Relationships between table are not shown in the ER diagram -
Description
Don't get any auto relationships. Oracle data tables, created thru Toad, have primary keys. Do not see a way to specify foreign keys.
,
-
Resolution
TDA only display the tables that are linked together when it's created. You will not be able to modify that change to the tables in the database. You can load these tables to the ER diagram and manually join these tables and save the diagram, but the link or join will not be made in the database. Tables that are already link or join in the database, automatically appears in the ER diagram if you drag one table over.
If you have Toad for Oracle you can add constraints and FK to existing table but Toad for Data Analysts does not have this capability.