Bug #642: Need "Alter table drop column"

Richard Neill (richard-n(at)richardneill(dot)org) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Need "Alter table drop column"

Long Description
Please can we have the option of "Alter table drop column "?

Otherwise, correcting a simple mistake of setting up a column as varchar 50 and discovering later that varchar 70 would have been better requires a complete copy of the table to be made via select into. This also breaks sequences, and primary keys. The obvious workaround is alter table add column new, update table set new=old, alter table drop column old, alter table column new rename to old. But the 3rd step can't be done!

Sample Code

No file was uploaded with this report