sql server drop unique constraint from a column code example

Example: mysql remove unique constraint

ALTER TABLE tbl_name DROP INDEX index_name