sql add unique constraint key 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)