The DROP CONSTRAINT command is used to delete a UNIQUE, PRIMARY KEY, FOREIGN KEY, or CHECK constraint.

Can we drop a constraints?

To drop constraints, use the ALTER TABLE statement with the DROP or DROP CONSTRAINT clauses. This allows you to BIND and continue accessing the tables that contain the affected columns. The name of all unique constraints on a table can be found in the SYSCAT.

How do you drop a constraint in db2?

1. To explicitly drop unique constraints, use the DROP UNIQUE clause of the ALTER TABLE statement. …
2. To drop primary key constraints, use the DROP PRIMARY KEY clause of the ALTER TABLE statement. …
3. To drop (table) check constraints, use the DROP CHECK clause of the ALTER TABLE statement.