sql server add unique column to existing table code example

Example 1: set column as unique in sql server

ALTER TABLE Persons
ADD UNIQUE (ID);

Example 2: unique key in sql

Unique Key:
Only unique value and also can contain NULL