Mark Tabor

Mark Tabor

  • 589
  • 2k
  • 460k

How to make a foreign key in sql server

Jun 28 2016 3:44 AM
I have a table in which i am making two columns as a combine as primary key i think this is called a composit key , Now in another table i want to make one of these two columns as foreign key when i tried that it gives an error , i think it is saying that i should include both columns from second table as well , check the link for table structure 
https://sweet-gmail.tinytake.com/sf/NzgwNjE0XzM1MTM1OTk 

Answers (4)