Dropping The Constraints

Syntax:

ALTER TABLE TABLENAME DROP CONSTRAINT CONSTRAINTNAME.

Example: ALTER TABLE DEPT DROP CONSTRAINT PK

From above example primary constraint have removed from DEPTNO columns.

Dropping The Constraints