SQL · Schema and constraints

unique

Rejects duplicate values across rows. Nulls are allowed multiple times in most databases.

sqlRunnable example sql course

Syntax

column text unique

Example

Open in the lab

CREATE TABLE users (
  email TEXT UNIQUE
);
SELECT name FROM sqlite_master WHERE name = 'users';

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