aspose file tools
The moose likes IDEs, Version Control and other tools and the fly likes Toad Modeler PFK issue Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Reply Bookmark "Toad Modeler PFK issue" Watch "Toad Modeler PFK issue" New topic
Author

Toad Modeler PFK issue

sreedhar Lackka
Ranch Hand

Joined: Jul 05, 2008
Posts: 154
Hi,

Thanks in advance.

I am using TDM (Toad Modeler) 4.0.6.15 for my design.

Exanple: I have 3 tables, say Table 1 ,Table2 and Table 3

Table 1 has Col1 as primary key and Table2 has Col2 which is a PK again. I draw a normal Relationship from Table1 to Table2 which created a PFK in Table which is correct and then I draw a realtionship from Table2 to Table 3 which created two PFKs however I was expecting only one PFK which is Col2 as PFK in Table3 but even col1 is also appearing in the Table3.

Please help me what to do

Regards,
Sree
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Toad Modeler PFK issue
 
Similar Threads
data migration from one table to the other
DB2 Update Sql based on calculation
full table scans
Update with FROM table concept
Improving performance of view