Back to lesson
1. What does the Alter Table statement allow us to do?
Rename your table.
Add New Columns
Add, Remove, or Update Column names and Data Types.
2. What's another name for "Delete" in SQL?
3. How do we change the data type of a column with SQL?
You can't - you'll get an error if you try.
With The Design Feature of SSMS.
With the ALTER COLUMN command in the ALTER TABLE Statement.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement