Flash cards
Review the key moves
What is the main idea behind SQL ALTER Keyword?
Lesson checks
Practice each idea before moving on
Short Mimo-style checks built from this lesson's code, terms, and sequence.
Which statement best captures the main point of this lesson?
Complete the missing token from the example code.
___ TABLE CustomersPut the learning moves in the order that makes the concept easiest to apply.
Alter Table
The ALTER TABLE command adds, deletes, or modifies columns in a table.
The ALTER TABLE command also adds and deletes various constraints in a table.
The following SQL adds an "Email" column to the "Customers" table:
Example
ALTER TABLE Customers
ADD Email varchar(255);The following SQL deletes the "Email" column from the "Customers" table:
Example
ALTER TABLE Customers
DROP COLUMN Email;Alter Column
The ALTER COLUMN command is used to change the data type of a column in a table.
The following SQL changes the data type of the column named "BirthDate" in the "Employees" table to type year:
Example
ALTER TABLE Employees
ALTER COLUMN BirthDate
year;