You are correct, Derby does not support dropping columns
in the ALTER TABLE statement.
The Derby Reference Manual for the ALTER TABLE statement lists PRIMARY KEYS, FOREIGN KEYS and CONSTRAINTS as the only supported objects to drop.
Bryan Pendleton <email@example.com> wrote:
alter table my_table drop column my_column;
and I got:
ERROR 42X01: Syntax error: Encountered "drop" at line 4, column 27.
Do I have a syntax error? Or does Derby simply not support
dropping columns from an existing table?