Please help: missing foreign keys
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Please help: missing foreign keys

Hybrid View

  1. #1
    Join Date
    Apr 2002
    Posts
    73
    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

  2. #2
    Join Date
    Jan 2002
    Posts
    148
    Easy way i would do it by downloading ERwin freeware.

  3. #3
    Join Date
    Jul 2002
    Location
    Washington DC
    Posts
    110

    Do a reverse enineering using ER win ,It will be helpful

    Manoj

  4. #4
    Join Date
    Nov 2000
    Posts
    224
    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
  •  



Click Here to Expand Forum to Full Width