-20567 TABLE table-name CANNOT BE DEFINED AS A DEPENDENT OF REFERENTIAL CONSTRAINT constraint-name. REASON reason-codereason-code.

Explanation

The object of an ALTER TABLE statement cannot be defined as a dependent table in a referential constraint for the reason indicated by the reason code.

table-name

The name of the table that is named as the dependent table.

constraint-name

The name of the referential constraint in which the altered table that is the dependent table.

reason-code

The reason for the message or SQL code, indicated by one of the following values:

1

PERIOD BUSINESS_TIME was specified as part of a temporal referential constraint definition that would result in a referential cycle. The parent and child tables must not be the same table in a temporal referential constraint, and the child table must not be a descendent, directly or indirectly, of another table that is a descendent of the parent table.

2

An index that enforces a temporal referential constraint contains an INCLUDE column. This is not allowed.