What is a Foreign Key ?

Posted by

To view Verified answers click on the button below.

When a “one” table’s primary key field is added to a related “many” table in order to create
the common field which relates the two tables, it is called a foreign key in the “many” table.
For example, salary of an employee is stored in salary table. Relation is established via
foreign key column “Employee_ID_Ref” which refers “Employee_ID” field in Employee table.