sql query to make a column unique code example

Example: set column as unique in sql server

ALTER TABLE Persons
ADD UNIQUE (ID);