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