Paycom interview question

Difference between foreign and primary key in SQL