Discussion Forum | Board Infinity

Difference between primary key and foreign key


Sql Question

A primary key uniquely identifies a record in the relational database table, whereas a foreign key refers to the field in a table which is the primary key of another table. A table can contain only one primary key whereas one or more than one foreign key.