Another area where cascade can be benefical is maintaining/changing large schemas that are deep into their life cycle. I have seen to many times where a critical, worthwhile schema addition has been shot down due to the inability to forcast all the touch points. I.E., I dont know who all can delete from my orders table and how they do it. (Yikes) A cascade at least allows you, for new entities, to ensure the new table will be cleaned up.