Re: Constraints primary and foreign key

From: Dan Townsend <townsend_at_ebmud.com>
Date: 1997/04/14
Message-ID: <33528D0A.1CCD_at_ebmud.com>#1/1

Camilla,
Barring the usual about not updating keys, you would:

(1) Create a duplicate row but using the new primary key.
(2) Update the foreign table with the new key.
(3) Delete the old primary key row.

Been there, know it needs to be done sometimes...

+-----------------------------------------------------
| Dan Townsend, Supervising Database Architect

| EBMUD Enterprise Object Designer
| mailto:townsend_at_ebmud.com

+-----------------------------------------------------

Camilla Straubel wrote:
>
> Hey!
>
> I have a problem.
> I have to update a primray key in a table. Another table has a foreign
> key to this table. What kind of statements do I use for this?
>
> Hoping for a fast answeer.
>
> /Camilla
Received on Mon Apr 14 1997 - 00:00:00 CEST