Jun 26, 2010

how to add unqiue key for existing column in a table in sqlserver

ALTER TABLE tbluser ADD CONSTRAINT IX_User_email UNIQUE(email)
ALTER TABLE tbluser ADD CONSTRAINT IX_User_mobile UNIQUE(mobile)
ALTER TABLE tbluser ADD CONSTRAINT IX_User_idtype UNIQUE(idtype)

No comments:

Post a Comment