NOT NULL constraint
A type of constraint that specifies that a column cannot contain any NULL values. It helps to preserve referential integrity, as the database server can identify data with erroneous missing values. It also helps in the arithmetic involved in query optimization, allowing the optimizer to predict the number of entries in an index on that column.
See also column.
See also constraint.
See also NULL.
See also primary key.
See also referential integrity.