A FOREIGN KEY is a field (or collection of fields) in one table, that refers to the PRIMARY KEY in another table. The table with the foreign key is called the child table, and the table with the primary key is called the referenced or parent table.

What is meant by foreign key?

A foreign key is a column or columns of data in one table that connects to the primary key data in the original table.

What is primary key and foreign key in SQL?

A primary key is used to assure the value in the particular column is unique. The foreign key provides the link between the two tables.