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