db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Cannot Use DROP in ALTER Table in NetBeans 6.0.1 (Derby Integrated)
Date Thu, 01 May 2008 13:08:13 GMT
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.


Mime
View raw message