Answer for Difference between MODIFY and CHANGE COLUMN when adding NOT NULL constraint for column

https://365datascience.com/dwqa-answer/answer-for-difference-between-modify-and-change-column-when-adding-not-null-constraint-for-column/ -

Hi Maros!

Thanks for reaching out.

Sometimes the two options can be used as alternatives. In other situations, you can use only one or the other. For instance, with CHANGE you are able to change the name of a column while using MODIFY disallows that. Therefore, they are interchangeable, and if you don’t need to change the column name, it is preferably to use MODIFY.

Throughout the course, we’ve used both to show that both can be used and because we did not want to deprive the course code from any of the two options.

Hope this helps.
Best,
Martin

#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy