SQL · Schema and constraints

primary key

Uniquely identifies each row and implies NOT NULL.

sqlRunnable example sql course

Syntax

id bigint primary key

Example

Open in the lab

CREATE TABLE lessons (
  id INTEGER PRIMARY KEY,
  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.