db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Devang kamdar" <dev.kam...@gmail.com>
Subject Cannot Use DROP in ALTER Table in NetBeans 6.0.1 (Derby Integrated)
Date Thu, 01 May 2008 10:17:14 GMT
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