Rolename in foreign key column

Toad Data Modeler
1

Can you have a different name for a column in a child table than the name on the primary key column it’s coming from?

2

Yes, see the attached picture. The PK in Entity1(parent) is Attribute1 but the FK in Entity2(child) is Attribute5.

[cid:image001.png@01CB6C4F.6EFA8880]

image001.png
image001.png1280×1024 47.4 KB

3

So I build the relationship first and then go into the column editor and change the name?

4

Hi Kim,
you can also rename the FK name in the child table. Please see the attached screen shot.

Regards,
Dave

RenAtr.png
RenAtr.png789×697 21.5 KB

5

Thanks Dave!