title: Does CASCADE Delete execute as transaction?
body: <p>I want to perform cascade delete for some tables in my database, but I'm interested in what happens in case there's a failure when deleting something. Will everything rollback?</p>