Small. Fast. Reliable.
Choose any three.
Choose any three.
|
DELETE
(lang_delete.html)
... The INDEXED BY and NOT INDEXED clauses are not allowed on DELETE
statements within triggers.
The LIMIT and ORDER BY clauses (described below) are unsupported for
DELETE statements within triggers.
The RETURNING clause is not supported for triggers.
3. Optional ...
|
|
C API: Constraint values in xBestIndex()
(c3ref/vtab_rhs_value.html)
sqlite3_vtab_rhs_value()
... When the sqlite3_vtab_rhs_value(P,J,V) interface is invoked from within
the xBestIndex method of a virtual table implementation, with P being
a copy of the sqlite3_index_info object pointer passed into xBestIndex and
J being a 0-based index into ...
|
|
CREATE TABLE
(lang_createtable.html)
... It is usually an error to attempt to create a new table in a database that
already contains a table, index or view of the same name. However, if the
"IF NOT EXISTS" clause is specified as part of the ...
|
|
The Virtual Database Engine of SQLite
(vdbe.html)
... Since the index is used to look up values in the table,
it is important that the index and table be kept consistent.
Now that there is an index on the examp table, we will have
to update that index ...
|
|
Implementation Limits For SQLite
(limits.html)
... Maximum Number Of Tables In A Schema
Each table and index requires at least one page in the database file.
An "index" in the previous sentence means an index created explicitly
using a CREATE INDEX statement or implicit indices created ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... SELECT name FROM sqlite_schema
WHERE type='table'
ORDER BY name;
For indices, type is equal to 'index', name is the
name of the index and tbl_name is the name of the table to which
the index belongs. For both tables ...
|
|
VACUUM
(lang_vacuum.html)
... Frequent inserts, updates, and deletes can cause the database file
to become fragmented - where data for a single table or index is scattered
around the database file. Running VACUUM ensures that each table and
index is largely stored contiguously within ...
|
|
C API: Create Or Redefine SQL Functions
(c3ref/create_function.html)
sqlite3_create_function(), sqlite3_create_function16(), sqlite3_create_function_v2(), sqlite3_create_window_function()
... The fourth parameter may also optionally include the SQLITE_DIRECTONLY
flag, which if present prevents the function from being invoked from
within VIEWs, TRIGGERs, CHECK constraints, generated column expressions,
index expressions, or the WHERE clause of partial indexes.
For best security ...
|
|
Change in Default Page Size in SQLite Version 3.12.0
(pgszchng2016.html)
... 3.0 Possible Negative Consequences Of This Change
The minimum size of an SQLite database is one page for each table and
each index. With a larger page size, the size of an empty database
for a given schema will ...
|
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
2.1. Queries
To query the geopoly table using an indexed geospatial search,
use one of the functions geopoly_overlap()
or geopoly_within() as a boolean function in the WHERE clause,
with the "_shape" column as the first argument to the function.
For example:
SELECT ...
|
Page generated by FTS5 in about 92.63 ms.