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?

2011-05-03

4,940 reads

Blogs

Event Notifications Example

By

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?

By

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

Batch Scripting SQLCMD–#SQLNewBlogger

By

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

Read the latest Blogs

Forums

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

By Syed_SQLDBA

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

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers