Toad World® Forums

Rolename in foreign key column


#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]


#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


#5

Thanks Dave!