Hi Dev,
Do you know what version of Derby you are using with Netbeans? Column
dropping and renaming were added to Derby in release 10.3.1.4.
Hope this helps,
-Rick
Devang kamdar wrote:
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.
