Check out example codes for "alter table add column with default value". It will help you in understanding the concepts better.

Code Example 1

ALTER TABLE Protocols
ADD ProtocolTypeID int NOT NULL DEFAULT(1)

Learn ReactJs, React Native from akashmittal.com