Ms Sql Enable Cascade Delete. this is well known sql server behaviour, two or more on delete paths from a child to a parent are not allowed. It is a kind of.
DELETE CASCADE and UPDATE CASCADE in SQL Server foreign key - image credit : www.sqlshack.com
You can just add on delete cascade to your foreign key. This constraint is used to delete the rows from the child table automatically, when the rows from the parent table. Delete permissions are required on the target table.select permissions.
DELETE CASCADE and UPDATE CASCADE in SQL Server foreign key
a foreign key with cascade delete means that if a record in the parent table is deleted, then the corresponding records in the child table will automatically be deleted. a foreign key with cascade delete means that if a record in the parent table is deleted, then the corresponding records in the child table will automatically be deleted. the best way to solve this to add on delete cascade constraint. there is a better solution than doing it in your code.
