Hi,
I have two tables , A and B where table B has a foreign key constraint
to table A.
I want to delete all records in table A that are older than a certain
date that are not referenced by table B.
When I use a DELETE FROM the entire transaction fails as soon as a
referential integrity violation is detected.
Is that the normal behavior? Is there a way to allow the deletion to
complete but skipping all those records that are referenced ?
Thanks in advance for any help.
Alex