I have a table A with two columns as Primary Key. Is it firstly possible.
Secondly, if the first column of table A(say C1) is set as PK1 and Foreign Key to another primary key column of table B.
Similarly, second column of table A (say C2) is set as PK2 and Foreign Key to another column of table C.
I wish to have a table created and the data to be added to C1 of Table A should allow repeatation( ie duplicate entries should be permissible.
In my limited understanding, can the C1 be a combination of PK1 and FK?
I am using SQL Server 2008