Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Shared-Cache Mode
(sharedcache.html)
4. Shared Cache And Virtual Tables
In older versions of SQLite,
shared cache mode could not be used together with virtual tables.
This restriction was removed in SQLite version 3.6.17 (2009-08-10).
|
|
The SQLite R*Tree Module
(rtree.html)
7.1. Shadow Tables
The content of an R*Tree index is actually stored in three ordinary
SQLite tables with names derived from the name of the R*Tree. These
three tables are called "shadow tables". This is their schema:
CREATE TABLE %_node(nodeno ...
|
|
ATTACH DATABASE
(lang_attach.html)
... Tables in an attached database can be referred to using the syntax
schema-name.table-name. If the name of the table is unique
across all attached databases and the main and temp databases, then the
schema-name prefix is ...
|
|
Query Planning
(queryplanner.html)
4. WITHOUT ROWID tables
The basic principals described above apply to both ordinary rowid tables
and WITHOUT ROWID tables.
The only difference is that the rowid column that serves as the key for
tables and that appears as the right-most term in indexes ...
|
|
C API: Source Of Data In A Query Result
(c3ref/column_database_name.html)
sqlite3_column_database_name(), sqlite3_column_database_name16(), sqlite3_column_table_name(), sqlite3_column_table_name16(), sqlite3_column_origin_name(), sqlite3_column_origin_name16()
These routines provide a means to determine the database, table, and
table column that is the origin of a particular result column in
SELECT statement.
The name of the database or table or column can be returned as
either a ...
|
|
The Session Extension
(sessionintro.html)
1.3. Limitations
Prior to SQLite version 3.17.0, the session extension only worked with
rowid tables, not WITHOUT ROWID tables. As of 3.17.0, both
rowid and WITHOUT ROWID tables are supported. However, extra steps are
needed to record primary ...
|
|
Partial Indexes
(partialindex.html)
2. Creating Partial Indexes
... show
common-table-expression:
show
compound-operator:
show
join-clause:
show
join-constraint:
show
join-operator:
show
ordering-term:
show
result-column:
show
table-or-subquery:
show
window-defn:
show
frame-spec:
show
type-name:
show
signed-number:
show
indexed ...
|
|
EXPLAIN QUERY PLAN
(eqp.html)
1.1. Table and Index Scans
When processing a SELECT (or other) statement, SQLite may retrieve data from
database tables in a variety of ways. It may scan through all the records in
a table (a full-table scan), scan a contiguous subset of the records ...
|
|
DELETE
(lang_delete.html)
... The table-name specified as part of a
DELETE statement within
a trigger body must be unqualified. In other words, the
schema-name. prefix on the table name is not allowed
within triggers. If the table to which the trigger ...
|
|
Indexes On Expressions
(expridx.html)
Normally, an SQL index references columns of a table. But an index
can also be formed on expressions involving table columns.
As an example, consider the following table that tracks
dollar-amount changes on various "accounts":
CREATE TABLE account_change(
chng_id ...
|
Page generated by FTS5 in about 146.86 ms.