db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: moving columns between tables
Date Tue, 19 Feb 2008 18:25:30 GMT
> 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.

thanks,

bryan



Mime
View raw message