Foreign Key relationships are widely used in SQL Server database design. They provide numerous benefits. However there are some associated issues while applying update/delete statements on parent table .i.e. table with referenced primary key. SQL Server provides rules to manage the effect of operation on child records. It is important to know the use and effects of these rules. Read my recently published article about Understanding the update and delete rules for SQL Server Foreign Key Relationships.
Constraints and Keys, Data Modeling and Database Design, dbDigger, Publications of Atif Shehzad on MSSQLTips.com