Enforcing unique values on a non-PK column 1

[Sashanan]

In Access, I'm able to enforce that every value in a column is unique even if said column isn't the primary key. Am I able to do the same in SQL Server 7?

I'll be able to solve this problem in my application too with a little recordset searching, but if it's as simple as setting a flag somewhere in Enterprise Manager I'd rather do that; unfortunately I haven't been able to find how or where.

Thanks in advance!


"Much that I bound, I could not free. Much that I freed returned to me."
(Lee Wilson Dodd)

 

[swampBoogie]

add a unique constraint for the column. Look it up in BOL.

 

[Sashanan]

Thanks, that's what I needed.


"Much that I bound, I could not free. Much that I freed returned to me."
(Lee Wilson Dodd)