>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. what is your use case ? Not sure what benefit you are talking about. thanks.