If a UNIQUE or PRIMARY KEY constraint has been created implicitly as a USI, you can remove it using a DROP INDEX statement that explicitly references the column set on which the constraint is defined.
If a UNIQUE or PRIMARY KEY constraint has been created implicitly as a USI, you can remove it using a DROP INDEX statement that explicitly references the column set on which the constraint is defined.