SQL · Schema and constraints

create unique index

Indexes a column and enforces uniqueness at the same time.

sqlRunnable example sql course

Syntax

create unique index …

Example

Open in the lab

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

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