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 14:24:12 GMT
On Friday 09 September 2005 09:22, Rick Hillegas wrote:
> Derby does have a RENAME TABLE command.
>
> Cheers,
> -Rick
>
Perfect.

If you were to enhance the Alter Table to allow for a DROP COLUMN foo, then 
you'd rename the existing table to a temp name, rebuild the table with all of 
the columns except the one that you're dropping, add all the constraints and 
indexes... then reload the new table and drop the temp.

Of course I'm probably missing something....

-- 
Michael Segel
Principal
MSCC
(312) 952-8175

Mime
View raw message