Thanks for the response Rick.
I am not able to verify from the IDE.
However, I checked the release notes online for NetBeans and it says, under tested drivers
NetBeans IDE 6.0 has been tested with the following databases and
|Oracle||Oracle Database 10g Release 2 (10.2.0.3)|
|PostgreSQL||8.2 Build 506|
|MySQL||MySQL Connector/J 5.0.7|
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,
Devang kamdar wrote:
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.