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.
