Re: Does Derby support ALTER TABLE DROP COLUMN?

[Rick Hillegas]

Hi Bryan,

Derby supports adding but not dropping columns. An enhancement request 
(396) has been filed on this issue.

Regards,
-Rick

Bryan Pendleton wrote:

I tried

  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?

thanks,

bryan