To insert a new column which is not null, ALTER TABLE statement can be used.

• Use ALTER TABLE statement to add a new column

• Specify the column name, data type, and NOT NULL constraint

• Set a default value ...read more