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.
