Question

what is the difference between primary key and foreign key​

Answer 1

Key Differences between Primary key and Foreign key. A primary is a set ofattributes/a candidate key that distinctly identifies a record in a relation. However, aforeign key in a table refers to the primary key of another table. ... However, foreign key constraint can not be applied to the temporary tables.

Answer 2

Key Differences between Primary key and foreign key.

A primary is a set of attributes/a candidate key that distinctly identifies a record in a relation. However, a foreign key in a table refers to the primary key of another table. ... However, foreign key constraint can not be applied to the temporary tables.
A primary key is a column or a set of columns that uniquely identify a row in a table. ... Usually a foreign key is in a table that is different from the table whose primary key is required to match. A table can have multiple foreign keys. The primary key cannot accept null values.