What do you mean by NOT NULL WITH DEFAULT?

[Krishna]

What do you mean by NOT NULL WITH DEFAULT? When will you use it?

[Krishna]

This column cannot have nulls and while insertion, if no value is supplied then it wil have zeroes, spaces or date/time depending on whether it is numeric, character or date/time.

Use it when you do not want to have nulls but at the same time cannot give values all the time you insert this row.