October 17, 2008 at 10:39 am
Hi,
Just one little question.
Can a primary key be a foreign key too?
thank you
October 17, 2008 at 10:45 am
Yes
October 17, 2008 at 10:50 am
Ok thanks....And in which context ?
October 17, 2008 at 10:51 am
In short yes. Check out this BOL subject
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/68ae44ef-990c-49c2-b502-ff1dc41b4019.htm
You can copy column properties from a primary key column to a foreign key column if you want to relate the two columns. Related columns must have the same data type (or data types that can be related) and length.
October 17, 2008 at 11:01 am
mk..... that the only context we can found this situation ?
Thank you
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply