Moving Tables with Constraints

The following table-level constraints are preserved in MOVE TABLE operations:

• UNIQUE
• NOT NULL
• CHECK
• PRIMARY KEY

All source table defaults are also preserved.

If you specify CASCADE mode, all referential constraints associated with source table are dropped when the MOVE TABLE statement executes. As part of this, all system-generated indexes for these constraints are also dropped. If an index has been explicitly created, however, it is preserved in the destination table.

By default, MOVE TABLE statement returns an error if any existing referential constraint references source table.

If a child table of source table has ON DELETE CASCADE set, the data of the child table is not affected, but its corresponding referential constraint is dropped. This behavior is the same as with the DROP TABLE statement.

By default, if source table is a parent table, then the MOVE TABLE statement fails. If source table is a child table, however, the MOVE TABLE operation succeeds.