Is best to define cascade operations (delete and update) when maintaining referential integrity or is it better to manually cascade deletes and updates in code? I initially thought it would be best to define cascade operations in the RDBMS, but I believe I may have read somewhere otherwise. I just want to hear the best approach so I know how to proceed with a project.

Thanks much ahead of time,
Craig