db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Dudgeon <tdudg...@informaticsmatters.com>
Subject Re: drop column functionality
Date Sat, 19 Aug 2006 17:21:36 GMT
Bryan Pendleton wrote:

> 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

Neither of those is an issue for me. My db is very simple.
I'll try the patch and see how it goes.

2 questions:

1. Should I apply the patch to the 10.1.3.1 sources (e.g. the 
db-derby-10.1.3.1-src.zip download) or something else?

2. Syntax: presumably
ALTER TABLE a_table DROP COLUMN a_column;


Thanks

Tim

Mime
View raw message