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