Can we use UPDATE to insert new column instead of ALTER in SQL ? | Sololearn: Learn to code for FREE!
¡Nuevo curso! ¡Todo programador debería aprender IA Generativa!
Prueba una lección gratuita
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 Respuesta
+ 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