NOT NULL Constraint

Also known as · NOT NULL

A constraint saying the column may not hold NULL, so a value is required.

sql
ALTER TABLE tour
  MODIFY guide_id INT NOT NULL;

When to use

PP 04 Q2.3 adds NOT NULL to the foreign key tour.guide_id so every tour has exactly one guide (MODIFY guide_id INT NOT NULL). PP 03 Q5 turns on it: a NOT NULL column with no default must be supplied in an INSERT. PP 05 Q3 shows nullable columns are optional.

See PP 02.

Appears in