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
