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

Hope this helps,

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:
> 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 raw message