-
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.
Thanks
Blu
-
Easy way i would do it by downloading ERwin freeware.
-
Do a reverse enineering using ER win ,It will be helpful
Manoj
-
Query DBA_CONSTRAINTS where constraint_type='R' additionally you can query DBA_CONS_COLUMNS to get the required info.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|