-632 THE TABLE CANNOT BE DEFINED AS A DEPENDENT OF table-name BECAUSE OF DELETE RULE RESTRICTIONS

Explanation

This code is used to report that the object of an ALTER TABLE statement cannot be defined as a dependent of the indicated table because either:
  • The relationship would form a cycle that would cause the table to be delete-connected to itself.
  • The relationship would cause the table to be delete-connected to the indicated table through multiple paths and the delete rule of the existing relationship is SET NULL.
The error is due to the delete rules of existing relationships, not the delete rule specified in the FOREIGN KEY clause of the ALTER TABLE statement.

System action

The statement cannot be processed.

Programmer response

Eliminate the particular FOREIGN KEY clause from the ALTER or CREATE TABLE statement.

SQLSTATE

42915