Hiroshi Inoue wrote:
> When I used Oracle,I saw neither option of DROP
> COLUMN feature. It seems to tell us that the
> implementation isn't
> that easy. It may not be a bad choise to give up DROP
> COLUMN feature forever.
Because it's not easy we shouldn't do it? I don't think so. The perfect
solution is lazy updating of tuples but it requires versioning of
meta-data and that requires a bit of work.
> However I would strongly object to 2x
> ADD COLUMN if such implementations are proposed.
Not even 2x for ADD COLUMN DEFAULT ?
