# How to change column names when synchronized from logical to physical erd

**URL:** <https://forums.visual-paradigm.com/t/how-to-change-column-names-when-synchronized-from-logical-to-physical-erd/21114>\
**Category:** How To\
**Tags:** erd\
**Created:** [September 8, 2024, 1:08am UTC](https://forums.visual-paradigm.com/t/how-to-change-column-names-when-synchronized-from-logical-to-physical-erd/21114 "2024-09-08T01:08:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guy\_Middleton](https://forums.visual-paradigm.com/user_avatar/forums.visual-paradigm.com/guy_middleton/32/7069_2.png) [@Guy\_Middleton](https://forums.visual-paradigm.com/u/Guy_Middleton)\
**Post date:** [September 8, 2024, 1:08am UTC](https://forums.visual-paradigm.com/t/how-to-change-column-names-when-synchronized-from-logical-to-physical-erd/21114/1 "2024-09-08T01:08:52Z")

</div>

I have a logical ERD model with a table (“Capabilities”), which has a one-to-many relationship to itself. If I synchronize the model to a physical ERD, the generated column name for the foreign key is CapabilitiesID. Is there any way to change the name? I would like it to be ParentID or something similar, as the relationship I am modelling is parent-to-children.

---

<div class="post-metadata">

**Author:** ![Rain](https://forums.visual-paradigm.com/user_avatar/forums.visual-paradigm.com/rain/32/2309_2.png) [@Rain](https://forums.visual-paradigm.com/u/Rain)\
**Post date:** [September 11, 2024, 10:04am UTC](https://forums.visual-paradigm.com/t/how-to-change-column-names-when-synchronized-from-logical-to-physical-erd/21114/2 "2024-09-11T10:04:10Z")

</div>

You can go to Window \> Project Options \> Diagramming \> ERD & ORM to specify the Foreign Key Pattern as {fk\_name}{reference\_column\_name}. In this case by specify name of the logical level relationship as “Parent”, then synchronize the logical ERD to physical ERD will have the FK column name generate as ParentID.

 ![image](https://forums.visual-paradigm.com/uploads/default/original/2X/2/2a67a373f24d8acfec683d522c1c6218aad5c001.png)
