KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have SQL Server 2008 R2 and I want to set a unique column. There seems to be two ways to do this: "unique index" and "unique constraint". They are not much different from what I understand, although unique constraint is recommended by most, because you also get an index automatically. How do I create a unique constraint? ALTER TABLE Customer ADD CONSTRAINT U_Name UNIQUE(Name) Is there a way to create a unique constraint through the SQL Server Management Studio?
Tags (comma-separated)
Save Edits
Cancel