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);
Relational Data Modeling - Unique (Constraint|Key) in SQlite
CREATE TABLE t1(a, b UNIQUE);
CREATE TABLE t1(a, b);
CREATE UNIQUE INDEX t1b ON t1(b);