It's a good question because it's one of the basics we've all run into at one point or another. I usually handle it by using an ALTER TABLE later in the code when necessary, but (as with everything) it depends on the situation.