Create FK regardless "no matching unique or primary key for this column-list"
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Create FK regardless "no matching unique or primary key for this column-list"

  1. #1
    Join Date
    Sep 2000
    Posts
    20

    Create FK regardless "no matching unique or primary key for this column-list"

    Hi, I need to create contraints to ensure the integrity of the future values. Just as the "novalidate" option for check constraints, is there a similar thing for foreign keys? I've tried "deferrable" and "novalidate" but I don't quite get how to make it work.... Please help, can I actually do this?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    enable the FK using novalidate clause, it works I have done it many times

  3. #3
    Join Date
    Jun 2003
    Location
    India
    Posts
    118
    use enable novalidate.

    Regards.
    vishal sood
    OCP 8

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