Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
Message-ID: <47BB1F1A.9020705@amberpoint.com>
Date: Tue, 19 Feb 2008 10:25:30 -0800
From: Bryan Pendleton <bpendleton@amberpoint.com>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: moving columns between tables
References: <eb9696930802191007ofa72c14i6bf14d9527d870c6@mail.gmail.com>
In-Reply-To: <eb9696930802191007ofa72c14i6bf14d9527d870c6@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

> 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