Click here to Skip to main content
14,971,553 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
How to set unique key in SQL server 2005 by Management Studio (Not by query) ?
Posted

You need to read a book (any book!) or refer number of tutorials on web...

There is a difference between unique key and primary key.
MSDN: Primary key Constraints[^]

MSDN: Unique Key Constraints[^]

After creating a table, you define the columns. There is a property window associated with a column created, use that for setting various properties/constraints for that column. There is a right click option too for setting selected constraints.
   
Browse this link
http://www.exforsys.com/tutorials/sql-server-2005/sql-server-defining-indexes.html
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900