WHERE ProductID = 1 Cascade with care You can use cascading constraints in SQL Server to set related values to NULL, to set affected values to original default values, or to delete columns.