Ever wished you could correct the mistakes of your past? Well, now is your chance. By using the ALTER command, you can apply all the lessons you’ve been learning to tables you designed days, months, even years ago. Even better, you can do it without affecting your data. By the time you’re through here, you’ll know what normal really means, and you’ll be able to apply it to all your tables, past and present.
Greg wants to make a few more changes to his table, but he doesn’t want to lose any data.
Yes, you can use ALTER TABLE to add it easily.
In fact, we think you should take a stab at it yourself since you’ve already met the
ALTER command. Do the next exercise to get your code!