I have inserted some data in a table where I should not have. I am trying to delete the data, but it has a 1:M relationship and I need to also delete data that references this one.
I do not want to alter the tables / indexes, I just need this instruction to cascade:
-- this alters the CONSTRAINT -- not an option: ALTER TABLE T2 ADD CONSTRAINT fk_employee FOREIGN KEY (employeeID) REFERENCES T1 (employeeID) ON DELETE CASCADE;
Also I would like (read - prefer) not to change the IDE GUI settings.