Something like this:


ALTER TABLE MyTable
ADD CONSTRAINT c_ColumnName_unq Unique (ColumnName)

--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."

*Yet Another Certification Exam


[quoted text, click to view]

that's it - I have a varchar(10) field (not null) which I need to add an
UNIQUE constraint to but I don't know how to?