Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Forward Engineer LDM to Relational Model Foreign Key Column Table Prefix Unwanted

Owen SingletonAug 20 2020 — edited Aug 21 2020

Hi,

I have a simple model which I'm using to learn this tool.  I have entities with 'Create Surrogate Key' ticked when I forward engineer to a relational model I get the surrogate key correctly formed as {Table Name}_ID but on the target table but it is in the form of {Table Name}_{Table Name}_ID.  Tearing my hair out on how to disable this behaviour so I just get an the original column name without a prefix.

I don't want to run a post script to modify the column name, I'd like the forward engineering to simply generate the foreign key column with the same name it has on the source table.

I'm using version 20.2.0.167.

Thanks!

Owen

This post has been answered by Saubhik on Aug 20 2020
Jump to Answer

Comments

Post Details

Added on Aug 20 2020
2 comments
444 views