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.