NOT NULL Constraint

By default, a column can hold NULL values. If you do not want a column to have a NULL value, then you need to define such constraint on this column.

This means that you cannot insert a new record, or update a record without adding a value to this field.A

Adding NOT NULL Constraint 

Drop NOT NULL Constraint

Advertisements