--Vamsi Effective Blogs "Make everything as simple as possible but not simpler"--
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment