SQL · Schema and constraints

check

Rejects rows that violate a domain rule.

sqlRunnable example sql course

Syntax

check (minutes > 0)

Example

Open in the lab

CREATE TABLE lessons (
  minutes INTEGER CHECK (minutes > 0)
);
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.