A CASCADE option (cascade_option) determines the deletion behavior for objects (e.g. tables, users). This means you define whether certain dependencies are to be taken into account when objects are deleted.
Syntax
<cascade_option> ::=
CASCADE
| RESTRICT
CASCADE: Dependencies are not taken into account
RESTRICT: Dependencies are taken into account