Now that you have a complete table with values and constraints, in this segment, you will learn how to:
- Add another column using the alter table and add commands,.
- Update a value in a column using the update and set commands, and.
- Delete a column using the alter table and drop column commands.
So, in the upcoming video, you will learn about these commands from our expert.
It is important that you know how to modify columns so that you can enter the right data immediately if you notice that some value has been incorrectly inserted into a particular column. Doing this will ensure that you get the right insights and make the right business decisions after analysing the correct data.
You have got the understanding of modifying the columns. In the next segment, you will be provided with some of the practice exercises.