SQL Server allows you to define cascading ... If a delete statement affects rows in a foreign key table, those values will be set to NULL when the primary key record is deleted.