Small. Fast. Reliable.
Choose any three.
Choose any three.
|
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 ...
|
|
Recovering Data From A Corrupt SQLite Database
(recovery.html)
1.1. Limitations
... CHECK constraints,
FOREIGN KEY constraints, UNIQUE constraints, type constraints on
STRICT tables - any of these might be violated in the recovered
database.
Content might be moved from one table into another.
The recovery API does as good of a job ...
|
|
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 ...
|
|
The RBU Extension
(rbu.html)
2.1. RBU Update Limitations
... The RBU update will not detect or prevent foreign key or
CHECK constraint violations.
All RBU updates use the "OR ROLLBACK" constraint handling mechanism.
The target database may not be in WAL mode.
The target database may not contain indexes ...
|
|
Syntax Diagrams For SQLite
(syntaxdiagrams.html)
... Used by: column-def
References: conflict-clause expr foreign-key-clause literal-value signed-number
See also: gencol.html lang_altertable.html lang_createtable ...
|
|
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 ...
|
|
Compile-time Options
(compile.html)
9. Options To Omit Features
... This option also disables enforcement of foreign key constraints,
since the code that implements triggers and which is omitted by this
option is also used to implement foreign key actions.
SQLITE_OMIT_TRUNCATE_OPTIMIZATION
This option omits the truncate optimization.
SQLITE_OMIT_UTF16
This macro ...
|
|
Recent SQLite News
(news.html)
... 2017-01-06 - Release 3.16.2
One of the performance optimizations added in 3.16.0 caused triggers
and foreign keys to malfunction for the REPLACE statement on
WITHOUT ROWID tables that lack secondary indexes. This patch
release fixes ...
|
|
C API: Database Connection Configuration Options
(c3ref/c_dbconfig_defensive.html)
SQLITE_DBCONFIG_MAINDBNAME, SQLITE_DBCONFIG_LOOKASIDE, SQLITE_DBCONFIG_ENABLE_FKEY, SQLITE_DBCONFIG_ENABLE_TRIGGER, SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER, SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION ...
... SQLITE_DBCONFIG_ENABLE_FKEY
This option is used to enable or disable the enforcement of
foreign key constraints. This is the same setting that is
enabled or disabled by the PRAGMA foreign_keys statement.
The first argument is an integer which is 0 to ...
|
|
SQLite Older News
(oldnews.html)
... 2009-10-14 - Version 3.6.19
SQLite version 3.6.19 adds native support for
foreign key constraints, including deferred constraints and
cascading deletes. Enforcement of foreign keys is disabled by
default for backwards compatibility and must be turned ...
|
Page generated by FTS5 in about 84.60 ms.