Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

How to customize FK Discovery

Kent GrazianoApr 22 2015 — edited Aug 11 2015

I have a 3rd party database that has PKs defined on every table but no FKs in the database. How do I get the FK Dsicover utility to find FK columns with this type of pattern:

Parent PK column = TABCUSTNUM

Child FK column = ABCCUSTNUM

So the root column name (CUSTNUM) is standard but in every table the column name has a different 3 character "prefix" that is effectively the table short name. Is there way to get the utility to ignore the first three characters of the column names?

This post has been answered by Philip Stoyanov-Oracle on Apr 24 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 8 2015
Added on Apr 22 2015
7 comments
2,145 views