MSSQL Create Unique Constraints 2008-06-13 2015-04-01 / MSSQL Server / Constraint, Unique / By Tim van Kooten Niekerk Example to create a unique constraint on a column. ALTER TABLE tablename ADD CONSTRAINT CK_Columnname UNIQUE (Columnname)