Figuring out all the referencing constraints sounds like a lot of work when you can just use the CASCADE CONSTRAINTS clause.