SQL Server allows you to define cascading ... This specifies that if an update or delete statement affects rows in foreign key tables, the action will be denied and rolled back.