Specifying the generated tables and columns name in the physical model

Hi all,

Is it possible to specify which naming convention we would like to use when generating the physical ERD from the logical ERD ?

for now, the physical tables are getting the column ID, and the foreign keys are my_tableID.
Would it be possible to have the column named id and the foreign keys named like my_table_id ?

Best regards,
Sylvain

Dear Sylvain,

Thank you for your inquiry. Please try the steps below:

  1. Select Window > Project Options from the main menu

  2. In the Project Options window, select “Diagramming” on the left

  3. Open the “ERD & ORM” tab

  4. Scroll down a bit. Add an underscore to the Foreign Key Pattern.

  5. Click OK to confirm.

Hope this helps. Feel free to let us know if you have any questions.

Best regards,
Jick Yeung

1 Like

Hi Jick, thanks a lot, it works great

You’re welcome :slight_smile: