Back to lesson
1. What does the Alter Table statement allow us to do?
Add New Columns
Add, Remove, or Update Column names and Data Types.
Rename your table.
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 ALTER COLUMN command in the ALTER TABLE Statement.
With The Design Feature of SSMS.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement