Question

how is primary key different from foreign key?

Answer 1

Difference between Primary and Foreign key in table - SQL. The database is a collection of tables and a table is the collection of rows or records. A primary key is the data to uniquely identify a row in the table. ... On the other hand, the foreign key is just the primary key of another table.

Answer 2

Simply, a primary key is a field that uniquely identifies each record in a table.
Whereas
Foreign key is a field that refference the primary key on another key.