Background documentationCASCADE Option (cascade_option) Locate this document in the navigation structure

 

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.

Structure

Syntax Syntax

  1. <cascade_option> ::=
      CASCADE
    | RESTRICT
End of the code.
Explanation

CASCADE: Dependencies are not taken into account

RESTRICT: Dependencies are taken into account