Richard Neill (richard-n@richardneill.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
havebeen better requires a complete copy of the table to be made via select into. This also breaks sequences, and
primarykeys. 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
