<div>
If both columns are the same/unique, then you should probably combine table A/table B into 1 table. Stick all of the columns (minus the PK) from table B into table A (or vice versa).<br />

</div>


If both columns are the same/unique, then you should probably combine table A/table B into 1 table. Stick all of the columns (minus the PK) from table B into table A (or vice versa).


<div>
no i can't modify the structure of table A<br />
because table B is a new table with a &quot;higher&quot; level to achieve new task<br />
table A cannot be modify...<br />
<br />
that's why we tried this solution, in management studio, we save the primary key of table A as a foreign key of primary key of table B<br />
and there is no error... and we did some test with success... and we tought that it was the good idea <br />
<br />
that's why i'm here to have suggestion of experts<br />
<br />
regards
</div>


no i can't modify the structure of table A
because table B is a new table with a "higher" level to achieve new task
table A cannot be modify...

that's why we tried this solution, in management studio, we save the primary key of table A as a foreign key of primary key of table B
and there is no error... and we did some test with success... and we tought that it was the good idea

that's why i'm here to have suggestion of experts

regards

<div>
ok, thank you guys :)<br />
<br />
regards
</div>


<div>
<div class="content wysiwyg-content">
Hi experts, <br />
<br />
i just want to know if it is a good thing to do such a thing : <br />
<br />
i have a primary key in table A and a primary key in table B<br />
<br />
i linked primary key A to primary key B<br />
<br />
because bot column have same value and have to be unique <br />
<br />
thank you in advance.<br />
<br />
regards
</div>
</div>


Hi experts, 

i just want to know if it is a good thing to do such a thing : 

i have a primary key in table A and a primary key in table B

i linked primary key A to primary key B

because bot column have same value and have to be unique 

thank you in advance.

regards

Link 2 primary key between them

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.