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