| |
- Causa
- THE TABLE CANNOT BE DEFINED AS A DEPENDENT OF table-name BECAUSE OF DELETE RULE RESTRICTIONS.
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.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- Eliminate the particular FOREIGN KEY clause from the ALTER or CREATE TABLE statement.
SQLSTATE: 42915
© Copyright IBM Corp.
|
| |
