If you need to make a change to a table's constraints (for example to drop an existing single column constraint in order to create a new compound column constraint) then use the following SQL:
ALTER TABLE tablename DROP CONSTRAINT constraint_name
e.g.
ALTER TABLE client DROP CONSTRAINT email_is_unique