Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Foreign Key Support
(foreignkeys.html)
6. Limits and Unsupported Features
... No support for the MATCH clause. According to SQL92, a MATCH clause
may be attached to a composite foreign key definition to modify the way
NULL values that occur in child keys are handled. If "MATCH SIMPLE" is
specified, then ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
... By the time foreign key constraint
enforcement was added, there were already countless millions of databases
in circulation that contained foreign key constraints, some of which
were not correct. To avoid breaking those legacy databases, foreign key
constraint enforcement is ...
|
|
SQLite Keywords
(lang_keywords.html)
... FAIL
FILTER
FIRST
FOLLOWING
FOR
FOREIGN
FROM
FULL
GENERATED
GLOB
GROUP
GROUPS
HAVING
IF
IGNORE
IMMEDIATE
IN
INDEX
INDEXED
INITIALLY
INNER
INSERT
INSTEAD
INTERSECT
INTO
IS
ISNULL
JOIN
KEY
LAST
LEFT
LIKE
LIMIT
MATCH
MATERIALIZED
NATURAL
NO
NOT
NOTHING
NOTNULL ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
... The conflicting row in this case is the database row with the matching
primary key.
SQLITE_CHANGESET_FOREIGN_KEY
If foreign key handling is enabled, and applying a changeset leaves the
database in a state containing foreign key violations, the conflict
handler is ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... Unfortunately, once humpty-dumpty falls off
the wall, it is generally not possible to put him back together again.
(22) Does SQLite support foreign keys?
As of version 3.6.19 (2009-10-14),
SQLite supports foreign key constraints. But ...
|
|
UPSERT
(lang_upsert.html)
... A "uniqueness constraint"
is an explicit UNIQUE or PRIMARY KEY constraint within
the CREATE TABLE statement, or a unique index.
UPSERT does not intervene for failed NOT NULL, CHECK,
or foreign key constraints
or for constraints that are implemented using ...
|
|
The Spellfix1 Virtual Table
(spellfix1.html)
3. Virtual Table Details
... This can be used
as a foreign key on other tables in the database.
word
The text of the word that matches the pattern.
Both word and pattern can contain unicode characters
and can be mixed case.
rank
This is ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... If P1 is non-zero, the database constraint counter is incremented
(deferred foreign key constraints). Otherwise, if P1 is zero, the
statement counter is incremented (immediate foreign key constraints).
FkIfZero
This opcode tests if a foreign key constraint-counter is ...
|
|
Pragma statements supported by SQLite
(pragma.html)
... PRAGMA defer_foreign_keys
PRAGMA defer_foreign_keys
PRAGMA defer_foreign_keys = boolean;
When the defer_foreign_keys PRAGMA is on,
enforcement of all foreign key constraints is delayed until the
outermost transaction is committed. The defer_foreign_keys pragma
defaults to OFF so that foreign key constraints are only ...
|
|
RETURNING
(lang_returning.html)
... The RETURNING clause
does not report any additional database changes
caused by foreign key constraints or triggers.
A RETURNING clause for an UPSERT reports both inserted and
updated rows.
2.1. Processing Order
When a DELETE, INSERT, or UPDATE statement ...
|
Page generated by FTS5 in about 42.41 ms.