Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 234 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 157 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 389 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
Forward Engineer LDM to Relational Model Foreign Key Column Table Prefix Unwanted
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
Best Answer
-
The thing you need to look is:
1. Right Click on your Data model -->Design properties .
2. When Generating Relational model then
Answers
-
The thing you need to look is:
1. Right Click on your Data model -->Design properties .
2. When Generating Relational model then
-
Thank you for your suggestion. I looked closely at the templates pane under Design properties. I found that there is an ability to set these properties and templates at a global level under Tools->Design Level Settings and also, optionally, at a specific model level if you right click on the top level model node under the Designs browser tree view control.
I had looked at these settings previously but was somewhat confused by the heading 'Table Constraints'. Most of the templates do indeed cover constraints but we also have "Column Foreign Key", "Surrogate Key Column" and "Discriminator Column" which can indeed be used to set the construction of these column names.
I did find that the Forward Engineer "Apply name translation" tick box had no effect on whether these templates were used or not. I believe this parameter controls whether glossary words are used to replace entity / attribute names.
Thanks again for your help!
Owen
