MSSQL Create Unique Constraints

Example to create a unique constraint on a column.

ALTER TABLE tablename ADD CONSTRAINT CK_Columnname UNIQUE (Columnname)