what is foreign key in sql server

A foreign key is a key used to link two tables together. This is sometimes also called as a referencing key , usually a primary key table is considered as a parent table while a foreign key table is considered as a child table .