Can we use UPDATE to insert new column instead of ALTER in SQL ? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Can we use UPDATE to insert new column instead of ALTER in SQL ?

7th Jul 2017, 9:56 PM
Chirag Singhal
Chirag Singhal - avatar
1 Answer
+ 1
UPDATE is DML command i.e. it manipulates only the data. ALTER is a DDL command i.e. it defines/alters the data structure. So you can only use ALTER for table structure change.
7th Jul 2017, 10:36 PM
Gurpreet Singh
Gurpreet Singh - avatar