db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stanley Bradbury <Stan.Bradb...@gmail.com>
Subject Re: Drop a Table Column using ij
Date Mon, 11 Dec 2006 19:21:46 GMT
DerbyDo wrote:
> Running the Derby software that comes packaged with Sun Java Studio Creator
> 2.1
>
> Trying to drop a column (which i added) from the Travel "database" table
> person
>
> I get an error that "drop" is bad (not recognized)
>
> My syntax:
>
> running windows XP SP2
> a<ij prompt from Command line> alter table person drop column conferencename
> cascade;
>
> I can do a select from the table using the column name which appears as:
> conference& instead of conferencename for some reason.
> the column name: conferencelocation display as expected: conferencelocation
> from a select statemnet...
>
> What is wrong with my "drop" syntax??
>
> Thanks
>
>   
Hi -

See the following link for supported alter table syntax, ..drop column 
is not currently supported in Derby.

http://db.apache.org/derby/docs/10.2/ref/rrefsqlj81859.html



Mime
View raw message