I'm probably missing something, but can anyone see a reason why adding an ADD OR ALTER COLUMN syntax to the ALTER TABLE command isn't either a) achievable or b) desirable?
It seems to me to be eminently useful and not overly difficult, while potentially saving a significant amount of effort on the part of users.
Geoff