Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: updating a primary key ???
Theoretically, no, but in your specific case, yes, you can update it. Note,
however, that if you have chosen your primary key wisely, you would not need
to update it. Some argue that this is one reason to use artificial keys. You
should review your choice of data for the PK.
"Brian" <boneill_at_calpoly.edu> wrote in message
news:3c9b8bcf$1_2_at_news.nntpserver.com...
> Hello,
>
> My question is whether or not is okay to update a primary key
> value as long as it is still unique (assuming no foreign key relations).
> Do most databases allow this, or is it necessary to delete the old
> record and re-insert with the new primary key?
>
> TIA,
> Brian
>
>
Received on Fri Mar 22 2002 - 14:37:37 CST