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 <[EMAIL PROTECTED]> 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.
