To automate this, you could define the foreign key constraint with ON DELETE CASCADE. I quote the the manual for foreign key constraints: CASCADE specifies that when a referenced row is deleted, row(s) referencing it should be automatically deleted as well. Look up the current FK definition like this: SELECT pg_get_constraintdef(oid) AS constraint_def FROM pg_constraint … Read more
From here:- Cascading Remove Marking a reference field with CascadeType.REMOVE (or CascadeType.ALL, which includes REMOVE) indicates that remove operations should be cascaded automatically to entity objects that are referenced by that field (multiple entity objects can be referenced by a collection field): @Entity class Employee { : @OneToOne(cascade=CascadeType.REMOVE) private Address address; : } Orphan Removal … Read more
I’m pretty sure you can’t simply add on delete cascade to an existing foreign key constraint. You have to drop the constraint first, then add the correct version. In standard SQL, I believe the easiest way to do this is to start a transaction, drop the foreign key, add a foreign key with on delete … Read more
orphanRemoval has nothing to do with ON DELETE CASCADE. orphanRemoval is an entirely ORM-specific thing. It marks “child” entity to be removed when it’s no longer referenced from the “parent” entity, e.g. when you remove the child entity from the corresponding collection of the parent entity. ON DELETE CASCADE is a database-specific thing, it deletes … Read more
There are two kinds of cascades in Doctrine: ORM level – uses cascade={“remove”} in the association – this is a calculation that is done in the UnitOfWork and does not affect the database structure. When you remove an object, the UnitOfWork will iterate over all objects in the association and remove them. Database level – … Read more
You will need to, Drop the existing foreign key constraint, Add a new one with the ON DELETE CASCADE setting enabled. Something like: ALTER TABLE dbo.T2 DROP CONSTRAINT FK_T1_T2 — or whatever it’s called ALTER TABLE dbo.T2 ADD CONSTRAINT FK_T1_T2_Cascade FOREIGN KEY (EmployeeID) REFERENCES dbo.T1(EmployeeID) ON DELETE CASCADE