DROP Clause

Drop an integrity constraint.

Syntax:

   DROP PRIMARY KEY [CASCADE]
   DROP UNIQUE column [CASCADE]
   DROP CONSTRAINT constraint_name

'column' can be either a single col name or several col's separated with commas,

Related Commands:

constraint - clause
disable - Disable a constraint

Related Views:

DBA_CONSTRAINTS    ALL_CONSTRAINTS    USER_CONSTRAINTS
DBA_CONS_COLUMNS   ALL_CONS_COLUMNS   USER_CONS_COLUMNS