There Is Already An Object Named 'IX_&<table&>' In The Database

Hi. I tried the following alter statement:


Code:


alter table userphotos
add constraint IX_userid unique (userid)



and got the following error:

Quote:
Msg 2714, Level 16, State 4, Line 3
There is already an object named 'IX_userid' in the database.
Msg 1750, Level 16, State 0, Line 3
Could not create constraint. See previous errors.

I previously created the same constraint in a different table (using IX_userid). Is it not allowed to use the same naming
scheme for constraints in different tables? What am I doing wrong?

Thanks.