Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Foreign Key Support
(foreignkeys.html)
Overview
This document describes the support for SQL foreign key constraints
introduced in SQLite version 3.6.19 (2009-10-14).
The first section introduces the
concept of an SQL foreign key by example and defines the terminology
used for the ...
|
|
DROP TABLE
(lang_droptable.html)
... By contrast, an
implicit DELETE FROM does cause any configured
foreign key actions to take place.
If the implicit DELETE FROM executed
as part of a DROP TABLE command violates any immediate foreign key constraints,
an error is returned and ...
|
|
ALTER TABLE
(lang_altertable.html)
... With
PRAGMA foreign_keys=OFF, FOREIGN KEY constraints would not be changed
when the table that the foreign key referred to (the "parent table")
was renamed. Beginning with version 3.26.0, FOREIGN KEY constraints
are always converted when a table ...
|
|
The Bytecode() And Tables_Used() Table-Valued Functions
(bytecodevtab.html)
2.1. Schema
... The
bytecode virtual tables shows all operations in the prepared statement,
both the main body of the prepared statement and in subprograms used
to implement triggers or foreign key actions. The "subprog" field
is NULL for the main body of ...
|
|
The ON CONFLICT Clause
(lang_conflict.html)
... The ON CONFLICT clause applies to UNIQUE, NOT NULL,
CHECK, and PRIMARY KEY constraints.
The ON CONFLICT algorithm does not
apply to FOREIGN KEY constraints.
There are five conflict resolution algorithm choices:
ROLLBACK, ABORT, FAIL, IGNORE, and REPLACE.
The default ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
4. Foreign Key Enforcement Is Off By Default
SQLite has parsed foreign key constraints for time out of mind,
but added the ability to actually enforce those constraints much later,
with version 3.6.19 (2009-10-14). By the time foreign key constraint
enforcement was added, there ...
|
|
List of SQLite Syntax Diagrams
(syntax.html)
... stmt
drop-index-stmt
drop-table-stmt
drop-trigger-stmt
drop-view-stmt
expr
factored-select-stmt
filter-clause
foreign-key-clause
frame-spec
function-arguments
indexed-column
insert-stmt
join-clause
join-constraint
join-operator
literal-value
numeric-literal ...
|
|
C API: Total Number Of Rows Modified
(c3ref/total_changes.html)
sqlite3_total_changes(), sqlite3_total_changes64()
... Changes made as part of foreign key actions are included in the
count, but those made as part of REPLACE constraint resolution are
not. Changes to a view that are intercepted by INSTEAD OF triggers
are not counted.
The sqlite3_total_changes ...
|
|
Full-Featured SQL
(fullsql.html)
... can use DESC and COLLATE
Partial indexes
Indexes On Expressions
Clustered indexes
Covering indexes
CHECK, UNIQUE, NOT NULL, and FOREIGN KEY constraints.
ACID transactions using BEGIN, COMMIT, and ROLLBACK
Nested transactions using SAVEPOINT, RELEASE, and
ROLLBACK TO
Subqueries, including correlated ...
|
|
CREATE TABLE
(lang_createtable.html)
... An optional PRIMARY KEY for the table. Both single column and
composite (multiple column) primary keys are supported.
Zero or more constraints on the table content.
SQLite supports UNIQUE, NOT NULL, CHECK and FOREIGN KEY constraints.
Optionally, a generated column ...
|
Page generated by FTS5 in about 49.89 ms.