Hi, I am trying to get started with Derby and Netbeans I am not able to use the DROP command.
Getting following error in NetBeans (Derby Integrated) Error code -1, SQL state 42X01: Syntax error: Encountered "DROP" at line 2, column 1. Line 1, column 1 Here is the SQL statement: ALTER TABLE TRAN DROP COLUMN TRAN_DESC Also, is there a way to rename a column? Right now I am trying to DROP it and ADD it again. I am just creating the DB, so there is no data at present and this seems reasonable work-around. But what if my DB is populated? If I Drop the column, I will loose all the data? Is there a viable alternative? Please let me know. Thanks Dev. -- View this message in context: http://www.nabble.com/Cannot-Use-DROP-in-ALTER-Table-in-NetBeans-6.0.1-%28Derby-Integrated%29-tp16993207p16993207.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
