• If you could alter tables the way you suggest, it would appear that you could also change the column order and type.

    Accidently changing the column order and type would cause nightmares.

    If you couldn't change the column order and type, altering tables this way would just be a huge pain in the a$$.