Toad World® Forums

Changing database joins in ER Diagram


#1

Quick question - in TDA 2.7 can I use the ER Diagram to change the dicovered joins in the database. An example would be… the database has an inner join between two tables, but I want to treat that as an outer join. Can I make that change in the ER Diagram?


#2

You can remove and add joins in the ER Diagrammer. Then send to Querybuilder. In the Query Builder you can change the join type.

Debbie