how to add unique constraint in sql server management studio code example
Example: sql server add unique constraint
-- Add a Unique constraint and deifine the constraint name
ALTER TABLE TableName
ADD CONSTRAINT TableName_ColumnName_Unique UNIQUE (ColumnName)