db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Does Derby support ALTER TABLE DROP COLUMN?
Date Fri, 09 Sep 2005 14:15:40 GMT
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
>


Mime
View raw message