How to drop unnamed unique constraint in ORACLE


The following statement drops the unique key on the email column of the employees table:

ALTER TABLE employees DROP UNIQUE (email);

The DROP clause in this statement omits the CASCADE clause. Because of this omission, Oracle Database does not drop the unique key if any foreign key references it.

Description of the illustration drop_constraint_clause

Advertisements