Answer for sql change and modify

https://365datascience.com/dwqa-answer/answer-for-sql-change-and-modify/ -

Hi Lisa!

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, as Vladimir suggested – With CHANGE you are able to change the name of a column while using MODIFY disallows that.

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.

That said, both are good to go in the NOT NULL Constraint lecture, as they can be interchangeable. Basically, the only difference is that you can alter a columns’ name when using CHANGE.

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