Question: what are the differences between primary key and foreign keys in sql server?
Answer: Difference between Primary Key and Foreign Key. Primary key uniquely identify a record in the table. Foreign key is a field in the table that is primary key in another table. Primary Key can't accept null values.