Composite Foreign Key
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Composite Foreign Key

  1. #1
    Join Date
    Aug 2000
    Posts
    132
    Is there a way to create a composite foreign key that contains 2 columns from different tables? The examples I've seen contain multiple cols but from the same table. Thanks.

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    I don't think such a thing is possible. The foreign key of a child table references the primary key of the parent table. In this case, a single column foreign key of one of the child table will be the same for the other child table, in which case, it does not make sense to have a composite foreign key.

  3. #3
    Join Date
    Aug 2000
    Posts
    132
    thanks Halo - that's what I figured

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