db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amir Michail" <amich...@gmail.com>
Subject Re: moving columns between tables
Date Tue, 19 Feb 2008 18:27:28 GMT
On Feb 19, 2008 1:25 PM, Bryan Pendleton <bpendleton@amberpoint.com> wrote:
> > Is there a way to easily move a column from one table to another (as
> > easy as a rename say)?
>
> alter table newtable add column newcolumn whatever-data-type;
> update newtable set newcolumn = (value that the newcolumn should have);
> alter table oldtable drop column oldcolumn;
>
> You'll also have to do some work to drop any constraints on
> the old column from the old table, then add those constraints
> to the new column in the new table once it's populated.

Can't all this be done automatically with a new move command?

Amir

>
> thanks,
>
> bryan
>
>
>

Mime
View raw message