db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thornton <mthorn...@optrak.co.uk>
Subject Re: how to remove a column
Date Fri, 07 Sep 2007 14:11:24 GMT
Brandon Dohman wrote:
> Is it possible to remove a column any other way?  Without using the 
> drop command?
Create a new table with the correct columns but a different name, copy 
content of the old table to the new one (except for the unwanted 
column). Drop any foreign key constraints referencing the old table. 
drop the old table. Rename the new table to the old name. Add back 
constraints if required.

I guess this wasn't what you wanted to know.

Mark Thornton

View raw message