A CASCADE option (cascade_option) determines the deletion behavior for objects (for example, tables, users), that is, it defines whether certain dependencies are to be taken into account when objects are deleted (dropped).
<cascade_option> ::= CASCADE | RESTRICT
CASCADE: Dependencies are not to be taken into account
RESTRICT: Dependencies are to be taken into account
Referential CONSTRAINT definition