Personal tools
You are here: Home → DB2 → How To's → How to drop a constraint on DB2
Navigation
Log in


Forgot your password?
 
Document Actions

How to drop a constraint on DB2

WARNING: take care of constraint created with quotes


Schema Name: group1
Table Name: EMPLOYEE
Constraint Name = KEY1


db2 alter table group1.employee drop constraint group1.key1


If the constraint was created between quotes, so you need to have attention when you will manipulate this constraint, example, when you will drop this constraint:


See the example below:


db2 set schema group1
db2 'alter table group1.employee drop constraint "key1"'
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls