Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA foreign_key_check
... The second column is the rowid of the row that
contains the invalid REFERENCES clause, or NULL if the child table is a
WITHOUT ROWID table. The third column is the name
of the table that is referred to. The ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.7. The copy method
... File-name must exist, and
each row must contain the same number of columns as defined in the table.
If a line in the file contains more or less than the number of columns defined,
the copy method rollbacks any ...
|
|
Database File Format
(fileformat.html)
2.6. Storage Of The SQL Database Schema
... CREATE TABLE sqlite_schema(
type text,
name text,
tbl_name text,
rootpage integer,
sql text
);
The sqlite_schema table contains one row for each table, index, view,
and trigger (collectively "objects") in the database schema, except there
is no entry for the sqlite_schema ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
14. Automatic Query-Time Indexes
... If each table contains N rows, SQLite expects that
the subquery will run N times, and hence it will believe it is faster
to construct an automatic, transient index on t2 first and then use
that index to satisfy the ...
|
|
Command Line Shell For SQLite
(cli.html)
11. Recover Data From a Corrupted Database
... value of rowid field, or NULL
c0, c1, c2, c3... -- columns for fields of row
);
The "lost_and_found" table contains one row for each orphaned row recovered
from the database. Additionally, there is one row for each recovered index
entry that ...
|
Page generated by FTS5 in about 33.55 ms.