Toad World® Forums

Rolename in foreign key column


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?


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



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


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



Thanks Dave!