About

Relational Data Modeling - Unique (Constraint|Key) in SQlite

Articles Related

Example

• B is Unique (and has no name)

CREATE TABLE t1(a, b UNIQUE);

• With a index name

CREATE TABLE t1(a, b);
CREATE UNIQUE INDEX t1b ON t1(b); 

Documentation / Reference

• https://www.sqlite.org/lang_createindex.html