Posted by Ed Murphy on 10/17/07 21:47

TGEAR wrote:

> I have a primary key (column name is emp_id) in employee table. Also,
> I would like to make a combination of other two columns is unique.
> (combination of officecode field and claimno field must be unique).
> how can I implement this uniquess in ms sql 2000? thank you.

alter table employee
add constraint officecode_claimno
unique (officecode, claimno)

[Back to original message]