Re: changing contents of primary key

why don't u add a link table for conversion from old key to the new one. Now you can use the new PK and old PK at the same time.

/Jacob

(U should read an oracle manual first, this is too elementary)

Sander Smit <S.V.Smit_at_kpn.com> schreef in artikel <7c5qq1$1cu$1_at_hdxl22.telecom.ptt.nl>...
> At the company I am working for, there is a database with a meaningful
> primary key: it contains the abbreviated company name.
> Now the company name has been changed, so we want to change the
> abbreviation. There are 25 other systems that have got an interface
> with our database, the primary key is one of the fields in the interface.
>
> Any suggestions? Thanks in advance.
>
> Regards, Sander
>
>
Received on Wed Mar 10 1999 - 10:38:08 CST