(Here’s more information on defining SQL Server constraints ... If a delete statement affects one or more rows in a foreign key table, those rows will be deleted when the primary key record ...