Primary key

Applies to: sql

A primary key uniquely identifies each row in a table. It should be stable, unique, and not null.

CREATE TABLE users (
  id INTEGER PRIMARY KEY,
  email TEXT
);

See also: foreign-key, index