You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by Shreyas Kaushik <Sh...@Sun.COM> on 2005/03/07 11:13:50 UTC

Droppping columns with ALTER TABLE

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