• I knew this one because I've been "bit" by it before. Would indeed be better if there was a warning.

    And for the why not create another table and move the data into that, there's DDL issues and possibly space issues, too. It's also many more steps.