MSSQL Create Unique Constraints Example to create a unique constraint on a column. ALTER TABLE tablename ADD CONSTRAINT CK_Columnname UNIQUE (Columnname)