|
THE DROP clause CLAUSE IN THE ALTER STATEMENT IS INVALID BECAUSE
constraint-name IS A constraint-type
Conclusão: 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.
SQLSTATE: 42809
© Copyright IBM Corp.
|
