SQL · Schema and constraints

not null

Rejects rows that leave the column empty. Add it to every column you always require.

sqlRunnable example sql course

Syntax

column text not null

Example

Open in the lab

CREATE TABLE lessons (
  title TEXT NOT NULL
);
SELECT name FROM sqlite_master WHERE name = 'lessons';

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.