logo  
Google
 

DB2 SQL-Error: -152

SQLState: 42809

Short Description: THE DROP CLAUSE IN THE ALTER STATEMENT IS INVALID BECAUSE IS A C E SQL DROP ALTER TABLE

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.System action: The ALTER TABLE DROP statement cannot be executed. No object was dropped. Programmer response: Drop the existing object with

 <-  BACK TO INDEX