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

Channel:

We Will Code

Subscribers:

8,020

Published on November 21, 2017 9:48:29 PM ● Video Link: https://www.youtube.com/watch?v=RWicuFVC1lw

Duration: 2:49

116 views

0

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.