Foreign Keys (FK)

SQL Server Foreign Key Update and Delete Rules

  • Article

Foreign key constraints are an integral part of SQL Server database design. These are used to maintain integrity among related data in different tables. While implementing update and delete operations on values in the parent table (referenced table with primary key) we have to consider the impact on related values in the child table. SQL Server provides different rules for managing the effect of updates and deletes on child table values. How can these rules be used effectively without threatening the relational integrity?


4,940 reads


Event Notifications Example


Event notifications are kinda like a trigger in the sense that they respond to...

Did you know we have another SQL Server book coming out?


SQL Server 2017 Administration Inside Out was the first technical book I contributed to,...

Batch Scripting SQLCMD–#SQLNewBlogger


Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs


Password changes

By Admingod

I would like my SQL users to be able to change their SQL password.Using...

Is a durable key always necessary in a dim?

By imani_technology

I want to use a Type 2 SCD SSIS transform on a dimension table...

Unable to shrink the log file


I have this on going issue where the log file of one of the...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers