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.

View raw message