Cascading referential integrity constraints are foreign key constraints that tell SQL Server to ... in a foreign key table, those values will be set to NULL when the primary key record is deleted.

I’ll explain this by using examples in DDL, using SQL Server syntax. The short version of this is fairly simple. Every table that you want to use in relations should have a primary key ...