Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Indexing, constraints Rss

   Items 1 to 1 of 1   
 

Should I Use a UNIQUE Constraint or a Unique Index in SQL Server?

I am modifying a table and I need to add a column that must be defined as being unique. I see that SQL Server allows you to define a UNIQUE constraint on a column but I also see that you can create a unique index on a column. Which one should I use?  Read more...
By Additional Articles 2008/09/05 | Source: MSSQLTips.com | Category: constraints
Rating:  Rate this |   Briefcase | 7,519 reads
   Items 1 to 1 of 1