Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com
SQLCode -152
Causa
THE DROP clause CLAUSE IN THE ALTER STATEMENT IS INVALID BECAUSE constraint-name IS A constraint-type
The DROP clause of an ALTER TABLE statement tried to drop a constraint that does not match the constraint-type in the DROP
clause. clause must identify an appropriate constraint-type as follows:
REFERENTIAL CONSTRAINT The identified constraint must be a referential constraint.
CHECK CONSTRAINT The identified constraint must be a check constraint.
PRIMARY KEY CONSTRAINT The identified constraint must be a primary key constraint.
UNIQUE KEY CONSTRAINT The identified constraint must be a unique key constraint.
Ação do sistema
The ALTER TABLE DROP statement cannot be executed. No object was dropped.
Resposta ao Desenvolvedor
Drop the existing object with the correct DROP clause of the ALTER TABLE statement.
