deleting rows with fk constraint

[new_developer]

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?

[PAVB]

There is no "cascade" option for the "delete" statement.