#foreign key in sql server

A foreign key (FK) is a column or group of columns used to create and enforce a link between data in two tables in order to control the data that can be put in the foreign key table. When the column or columns that carry the primary key value for one tabl

A foreign key (FK) is a column or group of columns used to create and enforce a link between data in two tables in order to control the data that can be put in the foreign key table. When the column or columns that carry the primary key value for one table are referenced by the column or columns in another table, a link is formed between the two tables. In the second table, this column becomes a…