db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stanley Bradbury <Stan.Bradb...@gmail.com>
Subject Re: I've a Question
Date Tue, 28 Jun 2005 16:55:28 GMT
The only way I know of to do this is a multi-step process

    create the new table without the unwanted column
    insert into NEW select <col-list> from OLD
    drop table OLD
    rename table NEW to OLD


Kumar Matcha wrote:

> Hi,
>
> I’ve a question. I’m using Derby as my applications database. I’ve a 
> scenario where in I’m in need to drop a column from a table.
>
> I know that Derby’s ALTER statement doesn’t support for DROP a column. 
> I would like to know, whether there is any other way of dropping
>
> a column through JDBC.
>
> Looking forward to your reply.
>
> Thanks,
>
> Regards,
>
> Kumar Matcha.
>



Mime
View raw message