What is the difference between a foreign key and a primary key in SQL?

A primary key uniquely identifies a record in a table, while a foreign key links records between two tables.

• Primary Key: Uniquely identifies each record in a table. Example: 'user_id' in a 'Users' tab...read more