Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com
SQLCode -633
Causa
THE DELETE RULE MUST BE delete-rule.
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'.
Ação do sistema
The statement cannot be executed.
Resposta ao Desenvolvedor
Change the 'delete rule' in the FOREIGN KEY clause.