db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Susan Cline <home4...@pacbell.net>
Subject Re: Does Derby support ALTER TABLE DROP COLUMN?
Date Fri, 09 Sep 2005 00:46:57 GMT
Hi Bryan,
You are correct, Derby does not support dropping columns
in the ALTER TABLE statement.
The Derby Reference Manual for the ALTER TABLE statement lists PRIMARY KEYS, FOREIGN KEYS
and CONSTRAINTS as the only supported objects to drop.

Bryan Pendleton <bpendleton@amberpoint.com> 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?



View raw message