Check out example codes for "add new column not null sql server". It will help you in understanding the concepts better.

Code Example 1

ALTER TABLE MY_TABLE
ADD STAGE INT NOT NULL
DEFAULT '0';

Learn ReactJs, React Native from akashmittal.com