The RESTRICT and CASCADE Options

You can use one of the RESTRICT or CASCADE keywords to specify how the MOVE TABLE statement treats dependencies among database objects. If you include neither of these keywords, the default mode is RESTRICT.

Specifying CASCADE Mode

The CASCADE keyword of MOVE TABLE removes the following database objects, if they exist, that are related to source table:

• Referential constraints that are defined on the table
• Views that are defined on the table
• Any violations table or diagnostics table that is associated with the table

Specifying RESTRICT Mode

The RESTRICT keyword has no effect unless source table has one or more referential constraints or views defined on it, or unless a violations or diagnostics table is associated with it. If you explicitly specify RESTRICT (or equivalently, if you do not specify CASCADE, thereby making RESTRICT the default mode), the MOVE TABLE operation fails with an error if any of the following conditions are true for source table:

• One or more referential constraints are defined on the table
• One or more views are defined on the table
• A violations table or diagnostics table is associated with the table

Unlike the DROP TABLE statement, whose default mode is CASCADE, the RESTRICT mode is the default mode for the MOVE TABLE statement.