There are two types of foreign keys in Toad Data Modeler:
As soon as you create an identifying relationship, Toad Data Modeler automatically adds a copy of the primary key of the Parent table to the Child table - Primary Foreign Key (PFK). (The foreign key in Child table is a part of the primary key.)
As soon as you create a non-identifying relationship, Toad Data Modeler automatically adds a copy of the primary key of the Parent table to the Child table - Foreign key (FK). (This foreign key in Child table is not a part of the primary key.)
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.
In Toad Data Modeler, information on foreign keys can be found in:
In Toad Data Modeler, you can control your foreign keys. Foreign keys mapping feature allows you to create Compound Keys, use existing keys etc.
You have reverse engineered a model without relationships. In Toad Data Modeler, a new model has been created. However, information about foreign keys has been lost as in Toad Data Modeler stands that foreign keys cannot exist without relationships. Now you need to create relationships in Toad Data Modeler.
As soon as you create a new relationship, a new foreign key is added to the child entity automatically or existing attribute is mapped to primary key automatically.
In case you need to choose different column for the relationship, edit the relationship and choose the new column on tab General.
You can also set Automatic FK Mapping in Settings | Options | Physical Model.
You can change the attribute name e. g. in the following cases:
You have just added a self-relationship to the Film entity.
Toad Data Modeler supports several database systems. As there are differences among databases, there are only applicable to specific databases.
Database platform and version specific information are listed in the respective topics in the Databases chapter.