Question on different ways to link tables

Posted by dotnetdev on Stack Overflow See other posts from Stack Overflow or by dotnetdev
Published on 2010-05-11T10:18:19Z Indexed on 2010/05/11 10:24 UTC
Read the original article Hit count: 185

Filed under:

What is the difference between linking two tables and then the PK is an FK in the other table, but the FK has not got the primary key option (so it does not have the gold key),

and having the PK in one table as a PK in another table?

Am I right to think that the second option is for a many-to-many relationship?

Thanks

© Stack Overflow or respective owner

Related posts about sql-server