db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Can't change column name, or drop database
Date Tue, 15 Apr 2008 20:55:31 GMT
> I finally just ran a script that dropped each table by name, and that 
> worked.  Seems like a painful way to rename a column!

Yes, that sounds quite painful. You should be able to use:

http://db.apache.org/derby/docs/10.3/ref/rrefsqljrenamecolumnstatement.html

Did you try that and fail? What was the exact failure? You defintely
do have to drop views, triggers, and constraints which reference that
column, and then recreate them, but that is hopefully much less painful than
entirely recreating the database from scratch.

thanks,

bryan


Mime
View raw message