set unique column in sql code example

Example: set column as unique in sql server

ALTER TABLE Persons
ADD UNIQUE (ID);