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!

SQL Developer Data Modeler - Relation to Foreign Key Generation

726041Aug 17 2010 — edited Aug 19 2010
SQL Developer Data Modeler 2.0.0 Build 584.

I am having trouble with Relations to Foreign Keys when Forward Engineering a Relational Model from a Logical Model.

First of all, the Naming Standard is not applied to the Foreign Keys when I perform the Engineer to Relational Model.

So I right click on the Relational Model from the Browser and Apply Naming Standards to Keys and Constraints.

I uncheck everything but Foreign Keys.

Now, Foreign Keys are named according to my Naming Standards.

However, this process also performs renames on the Column Foreign Keys even though I specifically unchecked that option.

This appears to be a BUG in the software and I haven't found a way around it.

I tried using {column} instead of {ref column} in the Naming Standard Template for Column Foreign Key, but that simply resulted in renaming my columns to "{column}".

Please confirm and/or let me know of any work-around for this.

Thanks,
Dan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2010
Added on Aug 17 2010
2 comments
1,416 views