if you alter a table to add a column and make it unable to accept null, what happens to the existing rows? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

if you alter a table to add a column and make it unable to accept null, what happens to the existing rows?

17th Aug 2016, 1:14 AM
Patrick Zanowski
Patrick Zanowski - avatar
2 Answers
+ 6
it will not be displayed because it needs to be in exact order
17th Aug 2016, 6:22 AM
Salad
Salad - avatar
0
nothing happens to existing row but affects only new item added in the table, that is altered row
18th Aug 2016, 9:15 AM
jeeva
jeeva - avatar