db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shreyas Kaushik <Shreyas.Kaus...@Sun.COM>
Subject Droppping columns with ALTER TABLE
Date Mon, 07 Mar 2005 10:13:50 GMT
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

Mime
View raw message