My Oracle Support Banner

How to Ensure Foreign Key Column Names Persist From Logical To Relational (Doc ID 2407708.1)

Last updated on JUNE 05, 2018

Applies to:

Oracle SQL Developer Data Modeler - Version 17.3 and later
Information in this document applies to any platform.

Goal

You are forward engineering a new design. When establishing Foreign Key constraints, you are renaming the column that gets auto-generated in the child table because there are occurrences that have two references. These names do not seem to persist when generating a Relational model.

For Example:

Table T1:
    id
    code

Table T2:
    id
    T1_code_a
    T1_code_b  


When generating the Relational model, table T2's columns will revert to:
  

    id
    T1_code
    T1_code2

 
How can the custom names in the Logical model be preserved in the Relational model?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.