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
