• GBimberg (2/27/2014)


    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$$.

    I'm not sure this is a good reason. A warning could be used here, and a good IDE would detect this. You might want this, but most likely not. However, are we not saying that programmers should be protected from making mistakes? I would argue that part of what we want to do is get programmers to be careful and confident of what they submit.

    In terms of ordering, does it matter? The physical implementation shouldn't matter. The order of columns in the CREATE TABLE should only be a semantic display issue for results, not impacting the physical storage. Surely we could handle meta data changes in system tables if someone reordered columns.