Unique constraint on multiple columns

• Mark Shvarts 1

  SSCertifiable

  Points: 5702

  More actions

  October 6, 2005 at 10:06 am

  #90207

  Hi,

  I need to create a Unique constraint on 4 columns. Is it possible ? If yes, what is script for this or how to do it in EM ?

  Or just creating a unique index on these columns would be enough ?

  Thanks

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  October 6, 2005 at 10:09 am

  #595553

  CREATE UNIQUE NONCLUSTERED INDEX IX_Name ON dbo.TableName (col1, col2, col3, col4)

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  October 6, 2005 at 6:13 pm

  #595736

  Some restrictions apply when creating Unique index on multiple columns, try the links below for more info.  Hope this helps.

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_8185.asp

  http://www.aspfaq.com/show.asp?id=2509

  Kind regards,

  Gift Peddie

  Kind regards,
  Gift Peddie