Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to set a column unique?

Author  Topic 

mshen
Starting Member

8 Posts

Posted - 2004-07-28 : 11:29:31
How to set a column unique with SQL server Enterprise manager tool?

Thanks

raymondpeacock
Constraint Violating Yak Guru

367 Posts

Posted - 2004-07-28 : 11:38:05
Right click the column and set it as Primary Key from the menu.


Raymond
Go to Top of Page

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2004-07-28 : 11:44:48
and what if he/she wanted 2 seperate columns unique??


right click the table, manage indices, add index (give it a name, column)...tag 'unique values'...and press OK until finished.
Go to Top of Page
   

- Advertisement -