| |
- Causa
- A NULLABLE COLUMN OF A FOREIGN KEY WITH A DELETE RULE OF SET NULL CANNOT BE A COLUMN OF THE KEY OF A PARTITIONED INDEX.
A partition key of the clustering index cannot be updated.
Therefore, a foreign key column with a delete rule of SET NULL cannot be a column of a partition key if that column is nullable.
If this error occurs for an ALTER TABLE operation, the foreign key cannot be created.
If this error occurs for a CREATE INDEX operation, the index cannot be created.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- Review the delete rule of the referential constraint and the partition keys for the index. Do one of the following:
- If the operation in error was CREATE INDEX, either change the index partition key definition or drop and redefine the referential constraint
with a different delete rule.
- If the operation in error was ALTER TABLE, change the referential delete rule so that all nullable index keys are not part of the foreign keys.
SQLSTATE: 56027
© Copyright IBM Corp.
|
| |
