-633 THE DELETE RULE MUST BE delete-rule

Explanation

The code is used to report that the 'delete-rule' specified in a FOREIGN KEY clause of the ALTER TABLE statement is invalid. The indicated 'delete-rule' is required because:
  • A self-referencing constraint must have a 'delete-rule' of CASCADE or NO ACTION.
  • The relationship would cause the table to be delete-connected to the same table through multiple paths and such relationships must have the same 'delete-rule'.
  • Start of changeWhen PERIOD BUSINESS_TIME is specified for a temporal referential constraint, the 'delete-rule' must be RESTRICT.End of change

System action

The statement cannot be processed.

Programmer response

Change the 'delete rule' in the FOREIGN KEY clause.

SQLSTATE

42915