DROP UNIQUE CONSTRAINT statement
The DROP UNIQUE CONSTRAINT statement removes a unique constraint from a table.

DROP UNIQUE CONSTRAINT tableOwner.tableName.uniqueConstraintName | This option specifies the fully qualified name of the unique constraint to be dropped. |
|---|
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*