Droppping columns with ALTER TABLE

[Shreyas Kaushik]

Hi all,
  I have seen this feature with other databases where droppping of 
columns is allowed using the ALTER TABLE command. When I try to do this 
with Derby i get the following error:

ij> alter table test_linux drop column dept;
ERROR 42X01: Syntax error: Encountered "drop" at line 1, column 24.
ij> alter table test_linux drop dept;
ERROR 42X01: Syntax error: Encountered "drop" at line 1, column 24.
I get the error message irrespective of whether I use the "column" 
keyword with drop or not.

thanks
Shreyas