Home » RDBMS Server » Server Administration » updating of a primary key
updating of a primary key [message #374612] Thu, 21 June 2001 04:52
yaku
Messages: 1
Registered: June 2001
Junior Member
I have allready specified a primary key and a value, but now i want to change that specific value with something like this:

Update Pub
set pub_id = 34
where pub_id = 56

I get the following error:

cannot update identity column

Report message to a moderator

Previous Topic: Creating a database
Next Topic: REF cursor type
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 17:58:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.