|
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)
Navigation:
[Reply to this message]
|