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