How we can add a NOT NULL column to a table

Question

Describe how we can add a NOT NULL column to a table?

Answer 1

First of all, add the column as NULL. Then employ UPDATE to add data to each and every row. Finally employ an ALTER TABLE . . . ALTER COLUMN statement to modify the column constraint to NOT NULL.