It looked like my new release of database was missing lots of the foreign keys, instead of checking each object in data model, have any ways I can have a script to list all of the foreign key suppose to be created and generate a create foreign key script for those missing one.
09-13-2002, 04:18 PM
Easy way i would do it by downloading ERwin freeware.
09-13-2002, 04:58 PM
Do a reverse enineering using ER win ,It will be helpful
09-13-2002, 06:07 PM
Query DBA_CONSTRAINTS where constraint_type='R' additionally you can query DBA_CONS_COLUMNS to get the required info.