#sql server foreign key relationships

A foreign key is a mechanism for ensuring referential integrity in the SQL Server database. A foreign key indicates that values from one table must also appear in another.

A foreign key is a mechanism for ensuring referential integrity in the SQL Server database. A foreign key indicates that values from one table must also appear in another. The referenced table is referred to as the parent table, while the table containing the foreign key is referred to as the child table. This means the foreign key in the child table will correspond to a main key in the parent…