Saturday, 10 November 2018

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);


No comments:

Post a comment