MS SQL Server Joins Interview Question:

Can you please explain the difference between primary keys and foreign keys?

Submitted by: Muhammad

Primary keys are the unique identifiers for each row. They must contain unique values and cannot be null. Due to their importance in relational databases, Primary keys are the most fundamental of all keys and constraints. A table can have only one Primary key. Foreign keys are both a method of ensuring data integrity and a manifestation of the relationship between tables.
Submitted by: Muhammad