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

Approaches to running Databricks ETL code from Azure ADF

By

Databricks is fantastic, but there is a small issue with how people use it....

Creating a New Sequence–#SQLNewBlogger

By

I wrote about sequences in an editorial recently and decided to start using them....

An All Star Lineup for EightKB

By

An online conference is coming on June 17, 2020 that is full of high...

Read the latest Blogs

Forums

Authentication failed

By adisql

Hi , Added source and Target servers as Linked servers  in Intermittent Server(Third Server).And...

Minus Query

By khwabekhan

Comments posted to this topic are about the item Minus Query

Do You Think About CheckDB?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Do You Think About CheckDB?

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Minus Query

See possible answers