Set a existing column of MS SQL table as NOT NULL

Question

How to Set a existing column of MS SQL table as NOT NULL?

Answer 1

ALTER TABLE tablename
ALTER COLUMN columnname datatype NOT NULL

You will obviously have to make sure that the column does not contain any NULL values before doing this.

Answer 2

You might also want to add a default contraint to the column.