db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta Satoor" <msat...@gmail.com>
Subject Re: Drop a Table Column using ij
Date Mon, 11 Dec 2006 19:21:56 GMT
Alter table drop column functionality is not yet into an official  Derby
release. Lot of work for the support of drop column has gone into the
current Derby codeline and will probably be available in next major Derby
release.

Mamta

On 12/11/06, DerbyDo <webmstr@uc.usbr.gov> 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
>
>
>
>
>
>
> --
> View this message in context:
> http://www.nabble.com/Drop-a-Table-Column-using-ij-tf2795661.html#a7799746
> Sent from the Apache Derby Developers mailing list archive at Nabble.com.
>
>

Mime
View raw message