General discussion

Locked

how to update a column which is a primary key

By jazzygodfrey ·
I have a table that keeps information of organization's members and each member is assigned a unique id, there are few members who for some reasons the organization has issued new id's to them, now I have been asked to update their new id's but SQL can not update them saying;
"Violation of PRIMARY KEY constraint 'PK_members'. Cannot insert duplicate key in object 'dbo.members'."

how do i do this?

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Web Development Forum
0 total posts (Page 1 of 1)  

Software Forums