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. 07-02-2005, 09:50 PM #1
    CeciMego
    CeciMego is offline Junior Member
    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?
    Reply With Quote Reply With Quote
  2. 07-03-2005, 07:16 AM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    enable the FK using novalidate clause, it works I have done it many times
    Reply With Quote Reply With Quote
  3. 07-03-2005, 03:52 PM #3
    vishal sood
    vishal sood is offline oracle DBA
    Join Date
    Jun 2003
    Location
    India
    Posts
    118
    use enable novalidate.

    Regards.
    vishal sood
    OCP 8
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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