If I have tables with FK constraints but do not have the 'on delete cascade' option set, do I need to write a delete statement for every table starting with the lowest child to delete all records? Or is there a cascade delete option for the delete statement?
