db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DerbyDo <webm...@uc.usbr.gov>
Subject Drop a Table Column using ij
Date Mon, 11 Dec 2006 18:01:33 GMT

Running the Derby software that comes packaged with Sun Java Studio Creator

Trying to drop a column (which i added) from the Travel "database" table

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

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??



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.

View raw message