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?