Question

what is the exact meaning of foreign key

Answer 1

Answer:

A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables. It acts as a cross-reference between tables because it references the primary key of another table, thereby establishing a link between them.

Answer 2

Answer:

In simpler words, a foreign key is a set of attributes that references a candidate key.

Explanation:

•A FOREIGN KEY is a key used to link two tables together.

•A FOREIGN KEY is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table.

•The table containing the foreign key is called the child table, and the table containing the candidate key is called the referenced or parent table.

•A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables.