But it looks like there is no ALTER TABLE DROP COLUMN ... functionality.
...
Is there an expectation for resolution?
Hi Tim, Thanks for considering Derby; I think you will find it is very powerful. You are correct that ALTER TABLE DROP COLUMN is not currently present. However, as you've observed, there is an active issue for it and that issue has a patch available. Can you try building Derby with the patch attached to that JIRA issue, and let us know if the feature appears to be working properly for you? Getting some additional testing would definitely accelerate the process of integrating this feature into the codeline. There are two open problems regarding that patch that I am still studying: - DROP COLUMN may not work properly if there are GRANTs on that column - DROP COLUMN may not work properly if there are VIEWs on that column Other than that, I believe that the feature is working properly, so it would be wonderful to get some additional experience about how it works "in real life". If you need assistance building Derby with the patch, please ask on the developers list (derby-dev@db.apache.org) and we'll be glad to help. thanks, bryan
