--Vamsi Effective Blogs "Make everything as simple as possible but not simpler"--
Showing posts with label
constraints
.
Show all posts
Showing posts with label
constraints
.
Show all posts
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)
Older Posts
Home
Subscribe to:
Posts (Atom)