Alter Table SQL Server

Making Unique key

Syntax :

alter table your_table add constraint constraint_Name  unique(yourcolumn);


Example :

alter table dbo.UserMaster add constraint unq_uname unique(UserName);

Next Example