SQL's ALTER Command, Learn SQL, Codecademy, Manipulation

Lesson Summary

In this lesson we go over the ALTER command from SQL. The alter command allows us to make specific changes to the table(s) we specify. The ALTER TABLE part of the command is a clause that lets SQL know you want to make a change. Following the clause is the name of the table(s) you want to change. Next the ADD COLUMN clause allows us to add a column. Next we add the column name and the data type it will be.

Subscribe To Monthly Newsletter. Chance to Win Monthly Prizes

* indicates required