Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Foreign Key Support
(foreignkeys.html)
3. Required and Suggested Database Indexes
... If they are not the primary key, then the parent key
columns must be collectively subject to a UNIQUE constraint or have
a UNIQUE index.
If the parent key columns have a UNIQUE index,
then that index must use the ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... A unique constraint is satisfied if and only if no two rows in a
table have the same non-null values in the unique columns.
That statement is ambiguous, having at least two possible interpretations:
A unique constraint is satisfied ...
|
|
Datatypes In SQLite version 2
(datatypes.html)
... CREATE TABLE t1(a INTEGER UNIQUE); CREATE TABLE t2(b TEXT UNIQUE);
INSERT INTO t1 VALUES('0'); INSERT INTO t2 VALUES(0);
INSERT INTO t1 VALUES('0.0'); INSERT INTO t2 VALUES(0.0);
In the sequence on the left ...
|
|
SQLite Autoincrement
(autoinc.html)
2. Background
In SQLite, table rows normally have a 64-bit signed integer ROWID
which is unique among all rows in the same table.
(WITHOUT ROWID tables are the exception.)
You can access the ROWID of an SQLite table using one of ...
|
|
Full-Featured SQL
(fullsql.html)
... Tables, indexes,
triggers, and views
in unlimited quantity
Up to 32K columns in a table and unlimited rows
Multi-column indexes
Indexes can use DESC and COLLATE
Partial indexes
Indexes On Expressions
Clustered indexes
Covering indexes
CHECK, UNIQUE, NOT NULL ...
|
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
3. Benefits Of WITHOUT ROWID Tables
... In an ordinary SQLite table, the PRIMARY KEY is really just a
UNIQUE index. The key used to look up records on disk
is the rowid.
The special "INTEGER PRIMARY KEY" column type in ordinary SQLite tables
causes the column ...
|
|
ATTACH DATABASE
(lang_attach.html)
... If the name of the table is unique
across all attached databases and the main and temp databases, then the
schema-name prefix is not required. If two or more tables in
different databases have the same name and the ...
|
|
The COMPLETION() Table-Valued Function
(completion.html)
2. Details
... The DISTINCT keyword and
the ORDER BY in the sample query above are added to make the answers unique
and in lexicographical order.
|
|
C API: Last Insert Rowid
(c3ref/last_insert_rowid.html)
sqlite3_last_insert_rowid()
Each entry in most SQLite tables (except for WITHOUT ROWID tables)
has a unique 64-bit signed
integer key called the "rowid". The rowid is always available
as an undeclared column named ROWID, OID, or _ROWID_ as long as those ...
|
|
ALTER TABLE
(lang_altertable.html)
... The column may not have a PRIMARY KEY or UNIQUE constraint.
The column may not have a default value of CURRENT_TIME, CURRENT_DATE,
CURRENT_TIMESTAMP, or an expression in parentheses.
If a NOT NULL constraint is specified, then the column must have ...
|
Page generated by FTS5 in about 108.99 ms.