Re: Sql proc

From: Rob van Wijk <rwijk72_at_gmail.com>
Date: Fri, 06 Jul 2007 09:41:12 -0000
Message-ID: <1183714872.464481.255940@o61g2000hsh.googlegroups.com>

On 5 jul, 15:36, "Oriane" <ori..._at_guermantes.fr> wrote:
> Hi there,
>
> I want to add an new column to my tables on a precise database. This column
> (an autoincrement index for instance) will be my primary key column. The old
> one will turn into a unique colum. Of course, there are foreign keys in the
> database...
>
> Is there a "well-known" proc to make the change and migrate the database so
> as to keep the constraints, but to apply them to the new primary keys ?
>
> Regards

Maybe this link is what you want?

http://asktom.oracle.com/tkyte/update_cascade/index.html

I haven't used it myself, but by reading it I thought it closely matched your requirements.

Regards,
Rob. Received on Fri Jul 06 2007 - 04:41:12 CDT