:::: MENU ::::

Understanding the update and delete rules for SQL Server Foreign Key Relationships

  • Apr 23 / 2011
  • 0
Constraints and Keys, Data Modeling and Database Design, dbDigger, Publications of Atif Shehzad on MSSQLTips.com

Understanding the update and delete rules for SQL Server Foreign Key Relationships

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.

Consult us to explore the Databases. Contact us