unique constraint with unique index

• trans54

  Ten Centuries

  Points: 1357

  More actions

  March 10, 2009 at 12:27 pm

  #384101

  I have a non clustered unique constraint defined on the table let's say on columns 1, 2, 3.

  Lots of queries would benefit if I add 1 more column in INCLUDE to cover queries but since unique constraint can't have INCLUDE clause I would like to drop unique constraint and recreate as a unique index with INCLUDE clause.

  But I want to make sure that by adding INCLUDE clause it will not affect the uniqueness of the columns 1, 2 and 3.

  Can you please verify if I am thinking correctly?

• GSquared

  SSC Guru

  Points: 260824

  More actions

  March 10, 2009 at 12:38 pm

  #957008

  You are correct. That should do what you need.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon