db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Does Derby support ALTER TABLE DROP COLUMN?
Date Fri, 09 Sep 2005 14:22:28 GMT
Derby does have a RENAME TABLE command.

Cheers,
-Rick

Michael J. Segel wrote:

>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...
>  
>


Mime
View raw message