I am using the modeler: 18.104.22.168 (newest freeware).
According to the instructions found in the helpfile @ mk:@MSITStore:C:\Program%20Files\Quest%20Software\Toad%20Data%20Modeler%203\Documents\Manual.chm::/Physical_Data_Model/Creating_Entity_Relationship_Diagram/Understanding_of_Foreign_Keys.htm
It has the following:
In other words, foreign keys (PFKs and FKs) are imported from parent entities to child entities automatically when you create relationship. Foreign keys cannot exist without relationships. Therefore, you are not allowed to delete FK or PFK from Child tables either. To delete them, you have to delete appropriate relationship.
I have deleted the appropriate relationship, then went to delete the FK. However, when double clicking on the FK attribute it claims it’s still related to the non-existing relationship, and refuses to allow me to delete it …
So, … is the help file wrong? Is there another way to delete FKs?