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