db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael J. Segel" <mse...@segel.com>
Subject Re: Does Derby support ALTER TABLE DROP COLUMN?
Date Fri, 09 Sep 2005 03:03:26 GMT
On Thursday 08 September 2005 20:09, wolfgang127us@yahoo.co.jp wrote:
> Hi Susan,
>
> Is there any other way we can drop columns
> which are not objects you mentioned ?
> or impossible ?
>
> thanks,
>
> Wolfgang
You could always do a simple work around.

I don't know if you can rename the table, you can always copythe data you want 
of the table to a temp table. Drop the table, then recreate with the missing 
column and reload.

Its sort of what the Alter Table would do...
-- 
Michael Segel
Principal
MSCC
(312) 952-8175

Mime
View raw message