Small. Fast. Reliable.
Choose any three.
Home
Menu
About
Documentation
Download
License
Support
Purchase
Search
About
Documentation
Download
Support
Purchase
Search for:
Keyword Index
Other Documentation Indexes:
Categorical Document List
Books About SQLite
Alphabetical List Of Documents
Permuted Document Title Index
35% Faster Than The Filesystem
about 200 SQL statements per webpage
abs() SQL function
advantages of WAL-mode
affinity
Affinity Of Expressions
Aggregate Functions
alphabetical listing of documents
ALTER TABLE
alter-table-stmt
alter-table-stmt syntax diagram
amalgamation
amalgamation tarball
American Fuzzy Lop fuzzer
ANALYZE
analyze-stmt
analyze-stmt syntax diagram
Application File Format
application file-format
Application ID
application-defined SQL function
application_id pragma
asynchronous I/O backend
asynchronous VFS
atomic commit
ATTACH DATABASE
attach-stmt
attach-stmt syntax diagram
attached
authorizer callback
authorizer method
auto_vacuum pragma
autocommit mode
AUTOINCREMENT
automated undo/redo stack
automatic indexing
automatic_index pragma
automatically running ANALYZE
"automerge" command
auxiliary function mapping
avg() aggregate function
avoiding large WAL files
B*-Trees
B-tree
backup API
backup method
bare aggregate terms
BEGIN EXCLUSIVE
BEGIN IMMEDIATE
BEGIN TRANSACTION
begin-stmt
begin-stmt syntax diagram
benefits of using WITHOUT ROWID
BETWEEN
BINARY collating function
binary operators
BLOB handle
BLOB I/O performance
block sorting
books about SQLite
boolean datatype
boolean expression
bound parameter
build product names
building a DLL
building the amalgamation
built-in memory allocators
busy handler
busy method
busy-handler callback
busy_timeout pragma
bytecode
bytecode engine
C-API function list
C-language Interface
cache method
"cache" query parameter
cache_size pragma
cache_spill pragma
canonical source code
carray
carray() table-valued function
CASE expression
case_sensitive_like pragma
CAST
CAST expression
CAST operator
categorical listing of SQLite documents
cell format summary
cell payload
cell_size_check pragma
cfgerrors*
change counter
changes method
changes() SQL function
char() SQL function
CHECK
CHECK constraint
checkpoint
checkpoint mode
checkpoint_fullfsync pragma
checkpointed
checkpointing
child key
child table
chronology
CLI
clone the entire repository
close method
Clustered indexes
coalesce() SQL function
code repositories
COLLATE
collate method
COLLATE operator
collating function
collation_list pragma
collation_needed method
column access functions
column affinity
column definition
column-constraint
column-constraint syntax diagram
column-def
column-def syntax diagram
column-name-list
column-name-list syntax diagram
colUsed field
Command Line Interface
command-line interface
command-line shell
commands
comment
comment-syntax
comment-syntax syntax diagram
COMMIT
commit-stmt
commit-stmt syntax diagram
commit_hook method
common table expressions
common-table-expression
common-table-expression syntax diagram
comparison affinity rules
comparison expressions
comparison with fts4
compile fts
compile loadable extensions
compile-time options
compile_options pragma
Compiling Loadable Extensions
compiling the CLI
compiling the TCL interface
complete list of SQLite releases
complete method
compound query
compound select
compound-operator
compound-operator syntax diagram
compound-select-stmt
compound-select-stmt syntax diagram
compressed FTS4 content
compute the Mandelbrot set
configurable edit distances
configuration option
conflict clause
conflict resolution mode
conflict-clause
conflict-clause syntax diagram
constraints
contentless fts4 tables
copy method
copyright
Core Functions
core URI query parameters
correlated subqueries
count() aggregate function
count_changes pragma
covering index
covering indices
CPU cycles used
CPU performance measurement
CREATE INDEX
CREATE TABLE
CREATE TABLE AS
CREATE TRIGGER
CREATE VIEW
CREATE VIRTUAL TABLE
create-index-stmt
create-index-stmt syntax diagram
create-table-stmt
create-table-stmt syntax diagram
create-trigger-stmt
create-trigger-stmt syntax diagram
create-view-stmt
create-view-stmt syntax diagram
create-virtual-table-stmt
create-virtual-table-stmt syntax diagram
CROSS JOIN
csv
CSV export
CSV import
CSV virtual table
cte-table-name
cte-table-name syntax diagram
custom auxiliary functions
custom builds
custom r-tree queries
custom tokenizers
data_store_directory pragma
data_version pragma
database connection
database corruption caused by inconsistent use of 8+3 filenames
database filename aliasing
database header
Database Object Name Resolution
database_list pragma
datatype
date and time datatype
date and time functions
date() SQL function
datetime() SQL function
dbghints
dbhash
dbhash.exe
dbstat
dbstat virtual table
debugging hints
debugging memory allocator
decision checklist
default column value
default memory allocator
default value
default_cache_size pragma
defer_foreign_keys pragma
DELETE
delete-stmt
delete-stmt syntax diagram
delete-stmt-limited
delete-stmt-limited syntax diagram
deleting a hot journal
deprecated
DESC
descending index
descending indexes
descending indices
DETACH DATABASE
detach-stmt
detach-stmt syntax diagram
deterministic function
deterministic SQL functions
-DHAVE_FDATASYNC
-DHAVE_GMTIME_R
-DHAVE_ISNAN
-DHAVE_LOCALTIME_R
-DHAVE_LOCALTIME_S
-DHAVE_MALLOC_USABLE_SIZE
-DHAVE_SQLITE_CONFIG_H
-DHAVE_STRCHRNUL
-DHAVE_USLEEP
-DHAVE_UTIME
DISTINCT
documents by category
dot-commands
download page
DROP INDEX
DROP TABLE
DROP TRIGGER
DROP VIEW
drop-index-stmt
drop-index-stmt syntax diagram
drop-table-stmt
drop-table-stmt syntax diagram
drop-trigger-stmt
drop-trigger-stmt syntax diagram
drop-view-stmt
drop-view-stmt syntax diagram
-DSQLITE_4_BYTE_ALIGNED_MALLOC
-DSQLITE_ALLOW_COVERING_INDEX_SCAN
-DSQLITE_ALLOW_URI_AUTHORITY
-DSQLITE_API
-DSQLITE_APICALL
-DSQLITE_BYTEORDER
-DSQLITE_CALLBACK
-DSQLITE_CASE_SENSITIVE_LIKE
-DSQLITE_CDECL
-DSQLITE_DEBUG
-DSQLITE_DEFAULT_AUTOMATIC_INDEX
-DSQLITE_DEFAULT_AUTOVACUUM
-DSQLITE_DEFAULT_CACHE_SIZE
-DSQLITE_DEFAULT_FILE_FORMAT
-DSQLITE_DEFAULT_FILE_PERMISSIONS
-DSQLITE_DEFAULT_FOREIGN_KEYS
-DSQLITE_DEFAULT_JOURNAL_SIZE_LIMIT
-DSQLITE_DEFAULT_LOCKING_MODE
-DSQLITE_DEFAULT_LOOKASIDE
-DSQLITE_DEFAULT_MEMSTATUS
-DSQLITE_DEFAULT_MMAP_SIZE
-DSQLITE_DEFAULT_PAGE_SIZE
-DSQLITE_DEFAULT_PCACHE_INITSZ
-DSQLITE_DEFAULT_SYNCHRONOUS
-DSQLITE_DEFAULT_WAL_AUTOCHECKPOINT
-DSQLITE_DEFAULT_WAL_SYNCHRONOUS
-DSQLITE_DEFAULT_WORKER_THREADS
-DSQLITE_DIRECT_OVERFLOW_READ
-DSQLITE_DISABLE_DIRSYNC
-DSQLITE_DISABLE_FTS3_UNICODE
-DSQLITE_DISABLE_FTS4_DEFERRED
-DSQLITE_DISABLE_INTRINSIC
-DSQLITE_DISABLE_LFS
-DSQLITE_ENABLE_8_3_NAMES
-DSQLITE_ENABLE_API_ARMOR
-DSQLITE_ENABLE_ATOMIC_WRITE
-DSQLITE_ENABLE_COLUMN_METADATA
-DSQLITE_ENABLE_DBSTAT_VTAB
-DSQLITE_ENABLE_EXPLAIN_COMMENTS
-DSQLITE_ENABLE_FTS3
-DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_ENABLE_FTS3_TOKENIZER
-DSQLITE_ENABLE_FTS4
-DSQLITE_ENABLE_FTS5
-DSQLITE_ENABLE_ICU
-DSQLITE_ENABLE_IOTRACE
-DSQLITE_ENABLE_JSON1
-DSQLITE_ENABLE_LOCKING_STYLE
-DSQLITE_ENABLE_MEMORY_MANAGEMENT
-DSQLITE_ENABLE_MEMSYS3
-DSQLITE_ENABLE_MEMSYS5
-DSQLITE_ENABLE_NULL_TRIM
-DSQLITE_ENABLE_PREUPDATE_HOOK
-DSQLITE_ENABLE_RBU
-DSQLITE_ENABLE_RTREE
-DSQLITE_ENABLE_SESSION
-DSQLITE_ENABLE_SQLLOG
-DSQLITE_ENABLE_STAT2
-DSQLITE_ENABLE_STAT3
-DSQLITE_ENABLE_STAT4
-DSQLITE_ENABLE_STMT_SCANSTATUS
-DSQLITE_ENABLE_TREE_EXPLAIN
-DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTION
-DSQLITE_ENABLE_UNLOCK_NOTIFY
-DSQLITE_ENABLE_UPDATE_DELETE_LIMIT
-DSQLITE_EXTRA_DURABLE
-DSQLITE_FTS3_MAX_EXPR_DEPTH
-DSQLITE_HAVE_ISNAN
-DSQLITE_LIKE_DOESNT_MATCH_BLOBS
-DSQLITE_MAX_MEMORY
-DSQLITE_MAX_MMAP_SIZE
-DSQLITE_MAX_SCHEMA_RETRY
-DSQLITE_MAX_WORKER_THREADS
-DSQLITE_MEMDEBUG
-DSQLITE_MINIMUM_FILE_DESCRIPTOR
-DSQLITE_OMIT_ALTERTABLE
-DSQLITE_OMIT_ANALYZE
-DSQLITE_OMIT_ATTACH
-DSQLITE_OMIT_AUTHORIZATION
-DSQLITE_OMIT_AUTOINCREMENT
-DSQLITE_OMIT_AUTOINIT
-DSQLITE_OMIT_AUTOMATIC_INDEX
-DSQLITE_OMIT_AUTORESET
-DSQLITE_OMIT_AUTOVACUUM
-DSQLITE_OMIT_BETWEEN_OPTIMIZATION
-DSQLITE_OMIT_BLOB_LITERAL
-DSQLITE_OMIT_BTREECOUNT
-DSQLITE_OMIT_BUILTIN_TEST
-DSQLITE_OMIT_CAST
-DSQLITE_OMIT_CHECK
-DSQLITE_OMIT_COMPILEOPTION_DIAGS
-DSQLITE_OMIT_COMPLETE
-DSQLITE_OMIT_COMPOUND_SELECT
-DSQLITE_OMIT_CTE
-DSQLITE_OMIT_DATETIME_FUNCS
-DSQLITE_OMIT_DECLTYPE
-DSQLITE_OMIT_DEPRECATED
-DSQLITE_OMIT_DISKIO
-DSQLITE_OMIT_EXPLAIN
-DSQLITE_OMIT_FLAG_PRAGMAS
-DSQLITE_OMIT_FLOATING_POINT
-DSQLITE_OMIT_FOREIGN_KEY
-DSQLITE_OMIT_GET_TABLE
-DSQLITE_OMIT_INCRBLOB
-DSQLITE_OMIT_INTEGRITY_CHECK
-DSQLITE_OMIT_LIKE_OPTIMIZATION
-DSQLITE_OMIT_LOAD_EXTENSION
-DSQLITE_OMIT_LOCALTIME
-DSQLITE_OMIT_LOOKASIDE
-DSQLITE_OMIT_MEMORYDB
-DSQLITE_OMIT_OR_OPTIMIZATION
-DSQLITE_OMIT_PAGER_PRAGMAS
-DSQLITE_OMIT_PRAGMA
-DSQLITE_OMIT_PROGRESS_CALLBACK
-DSQLITE_OMIT_QUICKBALANCE
-DSQLITE_OMIT_REINDEX
-DSQLITE_OMIT_SCHEMA_PRAGMAS
-DSQLITE_OMIT_SCHEMA_VERSION_PRAGMAS
-DSQLITE_OMIT_SHARED_CACHE
-DSQLITE_OMIT_SUBQUERY
-DSQLITE_OMIT_TCL_VARIABLE
-DSQLITE_OMIT_TEMPDB
-DSQLITE_OMIT_TRACE
-DSQLITE_OMIT_TRIGGER
-DSQLITE_OMIT_TRUNCATE_OPTIMIZATION
-DSQLITE_OMIT_UTF16
-DSQLITE_OMIT_VACUUM
-DSQLITE_OMIT_VIEW
-DSQLITE_OMIT_VIRTUALTABLE
-DSQLITE_OMIT_WAL
-DSQLITE_OMIT_WSD
-DSQLITE_OMIT_XFER_OPT
-DSQLITE_OS_OTHER
-DSQLITE_POWERSAFE_OVERWRITE
-DSQLITE_REVERSE_UNORDERED_SELECTS
-DSQLITE_RTREE_INT_ONLY
-DSQLITE_SECURE_DELETE
-DSQLITE_SORTER_PMASZ
-DSQLITE_SOUNDEX
-DSQLITE_STMTJRNL_SPILL
-DSQLITE_SYSCALL
-DSQLITE_TCLAPI
-DSQLITE_TEMP_STORE
-DSQLITE_THREADSAFE
-DSQLITE_TRACE_SIZE_LIMIT
-DSQLITE_UNTESTABLE
-DSQLITE_USE_FCNTL_TRACE
-DSQLITE_USE_URI
-DSQLITE_WIN32_HEAP_CREATE
-DSQLITE_WIN32_MALLOC
-DSQLITE_WIN32_MALLOC_VALIDATE
-DSQLITE_ZERO_MALLOC
dynamic typing
editdist3
embedded
empty_result_callbacks pragma
enable_load_extension method
encoding pragma
enhanced query syntax
eponymous virtual table
eponymous-only virtual table
errlog
error code
error log
errorcode method
ESCAPE
eval method
exists method
EXISTS operator
experimental
experimental memory allocators
EXPLAIN
explain dot-command
explain query plan
expr
expr syntax diagram
expression affinity
expression index
expression syntax
extended error code
extended result code
extended result code definitions
Extending FTS5
extension loading
external content fts4 tables
factored-select-stmt
factored-select-stmt syntax diagram
faster than the filesystem
file control opcode
file format
file I/O
file I/O functions
file locking and concurrency control
file locking states
file-format benefits
filesystem corruption
flattening optimization
footprint
foreign key actions
foreign key constraint
foreign key constraints are enabled
foreign-key-clause
foreign-key-clause syntax diagram
foreign_key_check pragma
foreign_key_list pragma
foreign_keys pragma
free-page list
freelist
freelist_count pragma
FROM clause
FTS auxiliary functions
FTS hidden column
FTS MATCH
FTS shadow tables
fts3_tokenizer
fts3tokenize
fts3tokenize virtual table
FTS4
FTS4 "automerge" command
FTS4 "integrity-check" command
FTS4 "merge" command
FTS4 "optimize" command
FTS4 "rebuild" command
FTS4 commands
fts4 compress option
FTS4 content option
FTS4 languageid option
FTS4 matchinfo option
FTS4 notindexed option
FTS4 options
FTS4 order option
FTS4 prefix option
fts4aux
fts4aux languageid column
FTS5 automerge option
FTS5 auxiliary functions
FTS5 bm25
FTS5 boolean operators
FTS5 building
FTS5 column filters
FTS5 columnsize option
FTS5 content option
FTS5 contentless tables
FTS5 CREATE TABLE Options
FTS5 custom auxiliary functions
FTS5 delete command
FTS5 delete-all command
FTS5 detail option
FTS5 external content tables
FTS5 highlight
FTS5 merge command
FTS5 NEAR queries
FTS5 optimize command
FTS5 pgsz option
FTS5 Phrases
FTS5 prefix indexes
FTS5 prefix queries
FTS5 query syntax
FTS5 rank configuration option
FTS5 rebuild command
FTS5 snippet
FTS5 Strings
fts5 technical differences
FTS5 tokenizers
FTS5 usermerge option
fts5vocab
Full-featured SQL
full-text search
full_column_names pragma
fullfsync pragma
.fullschema
function creation routines
function method
fuzz testing
generate_series
get the canonical source code
GLOB
glob() SQL function
GROUP BY
group_concat() aggregate function
HAVE_FDATASYNC
HAVE_GMTIME_R
HAVE_ISNAN
HAVE_LOCALTIME_R
HAVE_LOCALTIME_S
HAVE_MALLOC_USABLE_SIZE
HAVE_SQLITE_CONFIG_H
HAVE_STRCHRNUL
HAVE_USLEEP
HAVE_UTIME
hazards of upgrading to the NGQP
hex() SQL function
hexadecimal integer literals
hexadecimal integers
hidden column
high-reliability
host parameter
host parameter name
hot journal
how collation is determined
how to compile
How To Compile SQLite
how to corrupt
How To Corrupt Your Database Files
ifnull() SQL function
ignore_check_constraints pragma
"immutable" query parameter
.imposter dot-command
imposter tables
IN operator
in-header database size
in-memory database
in-memory shared cache database
in-memory shared-cache
incrblob method
increase in the default page size
incremental_vacuum pragma
index_info pragma
index_list pragma
index_xinfo pragma
INDEXED BY
indexed-column
indexed-column syntax diagram
indexes on expressions
indexing
indexing tutorial
INSERT
insert-stmt
insert-stmt syntax diagram
INSTEAD OF
INSTEAD OF trigger
instr() SQL function
INTEGER PRIMARY KEY
integer-valued r-trees
integrity_check pragma
internal index
internal indexes
internal schema object
internal table
Internal Versus External BLOBs
IS NOT operator
IS operator
isolation
join order
join-clause
join-clause syntax diagram
join-constraint
join-constraint syntax diagram
join-operator
join-operator syntax diagram
journal_mode pragma
journal_size_limit pragma
json
json SQL function
json1
json_array
json_array SQL function
json_array_length
json_array_length SQL function
json_each
json_each table-valued function
json_extract
json_extract SQL function
json_group_array
json_group_array SQL function
json_group_object
json_group_object SQL function
json_insert
json_insert SQL function
json_object
json_object SQL function
json_patch
json_patch SQL function
json_quote
json_quote SQL function
json_remove
json_remove SQL function
json_replace
json_replace SQL function
json_set
json_set SQL function
json_tree
json_tree table-valued function
json_type
json_type SQL function
json_valid
json_valid SQL function
julianday() SQL function
keyword index
languageid
large WAL files
last_insert_rowid method
last_insert_rowid() SQL function
legacy_file_format pragma
length() SQL function
library size
license
LIKE
LIKE optimization
like() SQL function
likelihood() SQL function
likely() SQL function
LIMIT
limit category
list of current bytecodes
literal value
literal-value
literal-value syntax diagram
load_extension() SQL function
loadable extension
loadext
localtime modifier
locking_mode pragma
long term support
lookaside
lookaside buffer
lookaside memory
lookaside memory allocator
low-dependency
lower() SQL function
ltrim() SQL function
mailing lists
Manual Control Of Query Plans Using CROSS JOIN
Manual Control Of Query Plans Using SQLITE_STAT Tables
master journal
MATCH
matchinfo
matchinfo b flag
matchinfo x flag
matchinfo y flag
max() aggregate function
max() SQL function
max_page_count pragma
MC/DC testing
memory
memory allocation
memory statistics
memory-mapped I/O
"merge" command
microoptimizations
min() aggregate function
min() SQL function
mmap
mmap_size pragma
"mode" query parameter
modeof
"modeof" query parameter
most used
most widely deployed
most widely used
mutation test script
mutation testing
NEAR queries
next generation query planner
NGQP
NOCASE collating function
"nolock" query parameter
non-deterministic functions
NOT EXISTS operator
NOT IN operator
NOT INDEXED
NOT NULL
NOT NULL constraint
nullif() SQL function
nullvalue method
numeric-literal
numeric-literal syntax diagram
object resolution
OFFSET
omitfeatures
ON CONFLICT
ON CONFLICT clause
onecolumn method
opcode definitions
opcodes
OpenOffice case study
optimize pragma
"optimize" command
optimizer
or optimization
or-connected-terms
order by
ordering-term
ordering-term syntax diagram
ordinary common table expressions
OS backend
OSS Fuzz
overflow page
page cache
page_count pragma
page_size pragma
pagecache memory allocator
parameter
parameter binding
parent key
parent table
parser_trace pragma
partial index
partial indexes
partial indices
partial sorting by index
permuted index
persistent loadable extensions
phrase queries
porting SQLite
power-safe
power-safe transactions
powersafe overwrite
PRAGMA
PRAGMA application_id
PRAGMA auto_vacuum
PRAGMA automatic_index
PRAGMA busy_timeout
PRAGMA cache_size
PRAGMA cache_spill
PRAGMA case_sensitive_like
PRAGMA cell_size_check
PRAGMA checkpoint_fullfsync
PRAGMA collation_list
PRAGMA compile_options
PRAGMA count_changes
PRAGMA data_store_directory
PRAGMA data_version
PRAGMA database_list
PRAGMA default_cache_size
PRAGMA defer_foreign_keys
PRAGMA empty_result_callbacks
PRAGMA encoding
PRAGMA foreign_key_check
PRAGMA foreign_key_list
PRAGMA foreign_keys
PRAGMA freelist_count
PRAGMA full_column_names
PRAGMA fullfsync
PRAGMA function
PRAGMA ignore_check_constraints
PRAGMA incremental_vacuum
PRAGMA index_info
PRAGMA index_list
PRAGMA index_xinfo
PRAGMA integrity_check
PRAGMA journal_mode
PRAGMA journal_size_limit
PRAGMA legacy_file_format
pragma list
PRAGMA locking_mode
PRAGMA max_page_count
PRAGMA mmap_size
PRAGMA optimize
PRAGMA page_count
PRAGMA page_size
PRAGMA parser_trace
PRAGMA query_only
PRAGMA quick_check
PRAGMA read_uncommitted
PRAGMA recursive_triggers
PRAGMA reverse_unordered_selects
PRAGMA schema_version
PRAGMA secure_delete
PRAGMA short_column_names
PRAGMA shrink_memory
PRAGMA soft_heap_limit
PRAGMA stats
PRAGMA synchronous
PRAGMA table_info
PRAGMA temp_store
PRAGMA temp_store_directory
PRAGMA threads
PRAGMA user_version
PRAGMA vdbe_addoptrace
PRAGMA vdbe_debug
PRAGMA vdbe_listing
PRAGMA vdbe_trace
PRAGMA wal_autocheckpoint
PRAGMA wal_checkpoint
PRAGMA writable_schema
pragma-stmt
pragma-stmt syntax diagram
pragma-value
pragma-value syntax diagram
prefix queries
prefix query
prepared statement
PRIMARY KEY
PRIMARY KEY constraint
primary versus extended result codes
printf() SQL function
prior releases
private branches
professional support
profile method
Programming Loadable Extensions
progress method
protected sqlite3_value
PSOW
"psow" query parameter
public-domain
qualified-table-name
qualified-table-name syntax diagram
query
query parameters with special meaning to SQLite
query planner
query planner checklist
query planner stability guarantee
query_only pragma
Quick Start Guide
quick_check pragma
quote() SQL function
R-Tree extension
R-Trees
RAISE function
raise-function
raise-function syntax diagram
random() SQL function
randomblob() SQL function
range query optimization
RBU
RBU Database Contents
RBU Database Tables
RBU extension
RBU FTS3/4 Tables
RBU Update
RBU Vacuum
read-only WAL databases
read_uncommitted pragma
"rebuild" command
recommended compile-time options
record format
recursive common table expression
recursive query
recursive-cte
recursive-cte syntax diagram
recursive_triggers pragma
REGEXP
REINDEX
reindex-stmt
reindex-stmt syntax diagram
RELEASE
release history
release-stmt
release-stmt syntax diagram
relfootprint
replace() SQL function
restore method
result code
result code definitions
result-column
result-column syntax diagram
result-set expressions
reverse_unordered_selects pragma
Robson proof
ROLLBACK
rollback journal
rollback journal format
rollback-stmt
rollback-stmt syntax diagram
rollback_hook method
round() SQL function
row value
ROWID
rowid table
rowvalue
RTRIM collating function
rtrim() SQL function
rules for determining column affinity
rules for determining column affinity in VIEWs
Run-Time Loadable Extensions
SAVEPOINT
savepoint-stmt
savepoint-stmt syntax diagram
scanstatus options
schema format
schema format number
schema_version pragma
scratch memory allocator
search application tips
second edition file format document
secure_delete pragma
segment btree
SELECT
select-core
select-core syntax diagram
select-stmt
select-stmt syntax diagram
self-contained
.selftest dot-command
serial type
series
server-side database
serverless
session
session extension
Session Extension C-language Interface
Session Module C-API function list
.sha3sum dot-command
shadow tables
shadowtabs
shared cache
shared cache mode
shims
short filenames
short_column_names pragma
shrink_memory pragma
signed-number
signed-number syntax diagram
simple fts queries
simple SELECT
simple-select-stmt
simple-select-stmt syntax diagram
skip-scan
skip-scan optimization
SLT
snapshot
snippet
soft_heap_limit pragma
solve Sudoku puzzles
sorting
sorting subsets of the result
soundex() SQL function
spellfix1
split amalgamation
SQL fuzzing
SQL Logic Tests
SQL parameter
SQL statement compiler
sql-stmt
sql-stmt syntax diagram
sql-stmt-list
sql-stmt-list syntax diagram
SQLAR smaller than ZIP
sqldiff
sqldiff --rbu
sqldiff.exe
SQLite Consortium
SQLite extension
SQLite Keywords
SQLite query planner
SQLite Shared-Cache Mode
SQLite source code repositories
sqlite3
sqlite3_aggregate_context
sqlite3_aggregate_count
sqlite3_analyzer
sqlite3_analyzer.exe
sqlite3_api_routines
sqlite3_auto_extension
sqlite3_backup
sqlite3_backup_finish()
sqlite3_backup_init()
sqlite3_backup_pagecount()
sqlite3_backup_remaining()
sqlite3_backup_step()
sqlite3_bind_blob
sqlite3_bind_blob64
sqlite3_bind_double
sqlite3_bind_int
sqlite3_bind_int64
sqlite3_bind_null
sqlite3_bind_parameter_count
sqlite3_bind_parameter_index
sqlite3_bind_parameter_name
sqlite3_bind_text
sqlite3_bind_text16
sqlite3_bind_text64
sqlite3_bind_value
sqlite3_bind_zeroblob
sqlite3_bind_zeroblob64
sqlite3_blob
sqlite3_blob_bytes
sqlite3_blob_close
sqlite3_blob_open
sqlite3_blob_read
sqlite3_blob_reopen
sqlite3_blob_write
sqlite3_busy_handler
sqlite3_busy_timeout
sqlite3_cancel_auto_extension
sqlite3_changegroup
sqlite3_changes
sqlite3_changeset_iter
sqlite3_clear_bindings
sqlite3_close
sqlite3_close_v2
sqlite3_collation_needed
sqlite3_collation_needed16
sqlite3_column_blob
sqlite3_column_bytes
sqlite3_column_bytes16
sqlite3_column_count
sqlite3_column_database_name
sqlite3_column_database_name16
sqlite3_column_decltype
sqlite3_column_decltype16
sqlite3_column_double
sqlite3_column_int
sqlite3_column_int64
sqlite3_column_name
sqlite3_column_name16
sqlite3_column_origin_name
sqlite3_column_origin_name16
sqlite3_column_table_name
sqlite3_column_table_name16
sqlite3_column_text
sqlite3_column_text16
sqlite3_column_type
sqlite3_column_value
sqlite3_commit_hook
sqlite3_compileoption_get
sqlite3_compileoption_used
sqlite3_complete
sqlite3_complete16
sqlite3_config
sqlite3_context
sqlite3_context_db_handle
sqlite3_create_collation
sqlite3_create_collation16
sqlite3_create_collation_v2
sqlite3_create_function
sqlite3_create_function16
sqlite3_create_function_v2
sqlite3_create_module
sqlite3_create_module_v2
sqlite3_data_count
sqlite3_data_directory
sqlite3_db_cacheflush
sqlite3_db_config
sqlite3_db_filename
sqlite3_db_handle
sqlite3_db_mutex
sqlite3_db_readonly
sqlite3_db_release_memory
sqlite3_db_status
sqlite3_declare_vtab
sqlite3_enable_load_extension
sqlite3_enable_shared_cache
sqlite3_errcode
sqlite3_errmsg
sqlite3_errmsg16
sqlite3_errstr
sqlite3_exec
sqlite3_expanded_sql
sqlite3_expired
sqlite3_extended_errcode
sqlite3_extended_result_codes
sqlite3_file
sqlite3_file_control
sqlite3_finalize
sqlite3_free
sqlite3_free_table
sqlite3_get_autocommit
sqlite3_get_auxdata
sqlite3_get_table
sqlite3_global_recover
sqlite3_index_info
sqlite3_initialize
sqlite3_int64
sqlite3_interrupt
sqlite3_io_methods
sqlite3_last_insert_rowid
sqlite3_libversion
sqlite3_libversion_number
sqlite3_limit
sqlite3_load_extension
sqlite3_log
sqlite3_malloc
sqlite3_malloc64
sqlite3_mem_methods
sqlite3_memory_alarm
sqlite3_memory_highwater
sqlite3_memory_used
sqlite3_module
sqlite3_module.xBegin
sqlite3_module.xBestIndex
sqlite3_module.xClose
sqlite3_module.xColumn
sqlite3_module.xCommit
sqlite3_module.xConnect
sqlite3_module.xCreate
sqlite3_module.xDisconnect
sqlite3_module.xEof
sqlite3_module.xFilter
sqlite3_module.xFindFunction
sqlite3_module.xNext
sqlite3_module.xOpen
sqlite3_module.xRename
sqlite3_module.xRollback
sqlite3_module.xRowid
sqlite3_module.xSavepoint
sqlite3_module.xSync
sqlite3_module.xUpdate
sqlite3_mprintf
sqlite3_msize
sqlite3_mutex
sqlite3_mutex_alloc
sqlite3_mutex_enter
sqlite3_mutex_free
sqlite3_mutex_held
sqlite3_mutex_leave
sqlite3_mutex_methods
sqlite3_mutex_notheld
sqlite3_mutex_try
sqlite3_next_stmt
sqlite3_open
sqlite3_open16
sqlite3_open_v2
sqlite3_os_end
sqlite3_os_init
sqlite3_overload_function
sqlite3_pcache
sqlite3_pcache_methods2
sqlite3_pcache_page
sqlite3_prepare
sqlite3_prepare16
sqlite3_prepare16_v2
sqlite3_prepare_v2
sqlite3_preupdate_count
sqlite3_preupdate_depth
sqlite3_preupdate_hook
sqlite3_preupdate_new
sqlite3_preupdate_old
sqlite3_profile
sqlite3_progress_handler
sqlite3_randomness
sqlite3_realloc
sqlite3_realloc64
sqlite3_release_memory
sqlite3_reset
sqlite3_reset_auto_extension
sqlite3_result_blob
sqlite3_result_blob64
sqlite3_result_double
sqlite3_result_error
sqlite3_result_error16
sqlite3_result_error_code
sqlite3_result_error_nomem
sqlite3_result_error_toobig
sqlite3_result_int
sqlite3_result_int64
sqlite3_result_null
sqlite3_result_subtype
sqlite3_result_text
sqlite3_result_text16
sqlite3_result_text16be
sqlite3_result_text16le
sqlite3_result_text64
sqlite3_result_value
sqlite3_result_zeroblob
sqlite3_result_zeroblob64
sqlite3_rollback_hook
sqlite3_rtree_query_callback
sqlite3_session
sqlite3_set_authorizer
sqlite3_set_auxdata
sqlite3_set_last_insert_rowid
sqlite3_shutdown
sqlite3_sleep
sqlite3_snapshot
sqlite3_snapshot_cmp
sqlite3_snapshot_free
sqlite3_snapshot_get
sqlite3_snapshot_open
sqlite3_snapshot_recover
sqlite3_snprintf
sqlite3_soft_heap_limit
sqlite3_soft_heap_limit64
sqlite3_sourceid
sqlite3_sql
sqlite3_status
sqlite3_status64
sqlite3_step
sqlite3_stmt
sqlite3_stmt_busy
sqlite3_stmt_readonly
sqlite3_stmt_scanstatus
sqlite3_stmt_scanstatus_reset
sqlite3_stmt_status
sqlite3_strglob
sqlite3_stricmp
sqlite3_strlike
sqlite3_strnicmp
sqlite3_system_errno
sqlite3_table_column_metadata
sqlite3_temp_directory
sqlite3_test_control
sqlite3_thread_cleanup
sqlite3_threadsafe
sqlite3_total_changes
sqlite3_trace
sqlite3_trace_v2
sqlite3_transfer_bindings
sqlite3_uint64
sqlite3_unlock_notify
sqlite3_update_hook
sqlite3_uri_boolean
sqlite3_uri_int64
sqlite3_uri_parameter
sqlite3_user_data
sqlite3_value
sqlite3_value_blob
sqlite3_value_bytes
sqlite3_value_bytes16
sqlite3_value_double
sqlite3_value_dup
sqlite3_value_free
sqlite3_value_int
sqlite3_value_int64
sqlite3_value_numeric_type
sqlite3_value_subtype
sqlite3_value_text
sqlite3_value_text16
sqlite3_value_text16be
sqlite3_value_text16le
sqlite3_value_type
sqlite3_version
sqlite3_vfs
sqlite3_vfs.xAccess
sqlite3_vfs.xOpen
sqlite3_vfs_find
sqlite3_vfs_register
sqlite3_vfs_unregister
sqlite3_vmprintf
sqlite3_vsnprintf
sqlite3_vtab
sqlite3_vtab_config
sqlite3_vtab_cursor
sqlite3_vtab_on_conflict
sqlite3_wal_autocheckpoint
sqlite3_wal_checkpoint
sqlite3_wal_checkpoint_v2
sqlite3_wal_hook
sqlite3changegroup_add
sqlite3changegroup_add_strm
sqlite3changegroup_delete
sqlite3changegroup_new
sqlite3changegroup_output
sqlite3changegroup_output_strm
sqlite3changeset_apply
sqlite3changeset_apply_strm
sqlite3changeset_concat
sqlite3changeset_concat_strm
sqlite3changeset_conflict
sqlite3changeset_finalize
sqlite3changeset_fk_conflicts
sqlite3changeset_invert
sqlite3changeset_invert_strm
sqlite3changeset_new
sqlite3changeset_next
sqlite3changeset_old
sqlite3changeset_op
sqlite3changeset_pk
sqlite3changeset_start
sqlite3changeset_start_strm
sqlite3session_attach
sqlite3session_changeset
sqlite3session_changeset_strm
sqlite3session_create
sqlite3session_delete
sqlite3session_diff
sqlite3session_enable
sqlite3session_indirect
sqlite3session_isempty
sqlite3session_patchset
sqlite3session_patchset_strm
sqlite3session_table_filter
SQLITE_4_BYTE_ALIGNED_MALLOC
SQLITE_ABORT
SQLITE_ABORT_ROLLBACK
SQLITE_ACCESS_EXISTS
SQLITE_ACCESS_READ
SQLITE_ACCESS_READWRITE
SQLITE_ALLOW_COVERING_INDEX_SCAN
SQLITE_ALLOW_URI_AUTHORITY
SQLITE_ALTER_TABLE
SQLITE_ANALYZE
SQLITE_ANY
SQLITE_API
SQLITE_APICALL
SQLITE_ATTACH
SQLITE_AUTH
SQLITE_AUTH_USER
SQLITE_BLOB
SQLITE_BUSY
SQLITE_BUSY_RECOVERY
SQLITE_BUSY_SNAPSHOT
SQLITE_BYTEORDER
SQLITE_CALLBACK
SQLITE_CANTOPEN
SQLITE_CANTOPEN_CONVPATH
SQLITE_CANTOPEN_FULLPATH
SQLITE_CANTOPEN_ISDIR
SQLITE_CANTOPEN_NOTEMPDIR
SQLITE_CASE_SENSITIVE_LIKE
SQLITE_CDECL
SQLITE_CHANGESET_ABORT
SQLITE_CHANGESET_CONFLICT
SQLITE_CHANGESET_CONSTRAINT
SQLITE_CHANGESET_DATA
SQLITE_CHANGESET_FOREIGN_KEY
SQLITE_CHANGESET_NOTFOUND
SQLITE_CHANGESET_OMIT
SQLITE_CHANGESET_REPLACE
SQLITE_CHECKPOINT_FULL
SQLITE_CHECKPOINT_PASSIVE
SQLITE_CHECKPOINT_RESTART
SQLITE_CHECKPOINT_TRUNCATE
sqlite_compileoption_get() SQL function
sqlite_compileoption_used() SQL function
SQLITE_CONFIG_COVERING_INDEX_SCAN
SQLITE_CONFIG_GETMALLOC
SQLITE_CONFIG_GETMUTEX
SQLITE_CONFIG_GETPCACHE
SQLITE_CONFIG_GETPCACHE2
SQLITE_CONFIG_HEAP
SQLITE_CONFIG_LOG
SQLITE_CONFIG_LOOKASIDE
SQLITE_CONFIG_MALLOC
SQLITE_CONFIG_MEMSTATUS
SQLITE_CONFIG_MMAP_SIZE
SQLITE_CONFIG_MULTITHREAD
SQLITE_CONFIG_MUTEX
SQLITE_CONFIG_PAGECACHE
SQLITE_CONFIG_PCACHE
SQLITE_CONFIG_PCACHE2
SQLITE_CONFIG_PCACHE_HDRSZ
SQLITE_CONFIG_PMASZ
SQLITE_CONFIG_SCRATCH
SQLITE_CONFIG_SERIALIZED
SQLITE_CONFIG_SINGLETHREAD
SQLITE_CONFIG_SQLLOG
SQLITE_CONFIG_STMTJRNL_SPILL
SQLITE_CONFIG_URI
SQLITE_CONFIG_WIN32_HEAPSIZE
SQLITE_CONSTRAINT
SQLITE_CONSTRAINT_CHECK
SQLITE_CONSTRAINT_COMMITHOOK
SQLITE_CONSTRAINT_FOREIGNKEY
SQLITE_CONSTRAINT_FUNCTION
SQLITE_CONSTRAINT_NOTNULL
SQLITE_CONSTRAINT_PRIMARYKEY
SQLITE_CONSTRAINT_ROWID
SQLITE_CONSTRAINT_TRIGGER
SQLITE_CONSTRAINT_UNIQUE
SQLITE_CONSTRAINT_VTAB
SQLITE_COPY
SQLITE_CORRUPT
SQLITE_CORRUPT_VTAB
SQLITE_CREATE_INDEX
SQLITE_CREATE_TABLE
SQLITE_CREATE_TEMP_INDEX
SQLITE_CREATE_TEMP_TABLE
SQLITE_CREATE_TEMP_TRIGGER
SQLITE_CREATE_TEMP_VIEW
SQLITE_CREATE_TRIGGER
SQLITE_CREATE_VIEW
SQLITE_CREATE_VTABLE
SQLITE_DBCONFIG_ENABLE_FKEY
SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION
SQLITE_DBCONFIG_ENABLE_TRIGGER
SQLITE_DBCONFIG_LOOKASIDE
SQLITE_DBCONFIG_MAINDBNAME
SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE
SQLITE_DBSTATUS options
SQLITE_DBSTATUS_CACHE_HIT
SQLITE_DBSTATUS_CACHE_MISS
SQLITE_DBSTATUS_CACHE_USED
SQLITE_DBSTATUS_CACHE_USED_SHARED
SQLITE_DBSTATUS_CACHE_WRITE
SQLITE_DBSTATUS_DEFERRED_FKS
SQLITE_DBSTATUS_LOOKASIDE_HIT
SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL
SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE
SQLITE_DBSTATUS_LOOKASIDE_USED
SQLITE_DBSTATUS_MAX
SQLITE_DBSTATUS_SCHEMA_USED
SQLITE_DBSTATUS_STMT_USED
SQLITE_DEBUG
SQLITE_DEFAULT_AUTOMATIC_INDEX
SQLITE_DEFAULT_AUTOVACUUM
SQLITE_DEFAULT_CACHE_SIZE
SQLITE_DEFAULT_FILE_FORMAT
SQLITE_DEFAULT_FILE_PERMISSIONS
SQLITE_DEFAULT_FOREIGN_KEYS
SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT
SQLITE_DEFAULT_LOCKING_MODE
SQLITE_DEFAULT_LOOKASIDE
SQLITE_DEFAULT_MEMSTATUS
SQLITE_DEFAULT_MMAP_SIZE
SQLITE_DEFAULT_PAGE_SIZE
SQLITE_DEFAULT_PCACHE_INITSZ
SQLITE_DEFAULT_SYNCHRONOUS
SQLITE_DEFAULT_WAL_AUTOCHECKPOINT
SQLITE_DEFAULT_WAL_SYNCHRONOUS
SQLITE_DEFAULT_WORKER_THREADS
SQLITE_DELETE
SQLITE_DENY
SQLITE_DETACH
SQLITE_DETERMINISTIC
SQLITE_DIRECT_OVERFLOW_READ
SQLITE_DISABLE_DIRSYNC
SQLITE_DISABLE_FTS3_UNICODE
SQLITE_DISABLE_FTS4_DEFERRED
SQLITE_DISABLE_INTRINSIC
SQLITE_DISABLE_LFS
SQLITE_DONE
SQLITE_DROP_INDEX
SQLITE_DROP_TABLE
SQLITE_DROP_TEMP_INDEX
SQLITE_DROP_TEMP_TABLE
SQLITE_DROP_TEMP_TRIGGER
SQLITE_DROP_TEMP_VIEW
SQLITE_DROP_TRIGGER
SQLITE_DROP_VIEW
SQLITE_DROP_VTABLE
SQLITE_EMPTY
SQLITE_ENABLE_8_3_NAMES
SQLITE_ENABLE_API_ARMOR
SQLITE_ENABLE_ATOMIC_WRITE
SQLITE_ENABLE_COLUMN_METADATA
SQLITE_ENABLE_DBSTAT_VTAB
SQLITE_ENABLE_EXPLAIN_COMMENTS
SQLITE_ENABLE_FTS3
SQLITE_ENABLE_FTS3_PARENTHESIS
SQLITE_ENABLE_FTS3_TOKENIZER
SQLITE_ENABLE_FTS4
SQLITE_ENABLE_FTS5
SQLITE_ENABLE_ICU
SQLITE_ENABLE_IOTRACE
SQLITE_ENABLE_JSON1
SQLITE_ENABLE_LOCKING_STYLE
SQLITE_ENABLE_MEMORY_MANAGEMENT
SQLITE_ENABLE_MEMSYS3
SQLITE_ENABLE_MEMSYS5
SQLITE_ENABLE_NULL_TRIM
SQLITE_ENABLE_PREUPDATE_HOOK
SQLITE_ENABLE_RBU
SQLITE_ENABLE_RTREE
SQLITE_ENABLE_SESSION
SQLITE_ENABLE_SQLLOG
SQLITE_ENABLE_STAT2
SQLITE_ENABLE_STAT3
SQLITE_ENABLE_STAT4
SQLITE_ENABLE_STMT_SCANSTATUS
SQLITE_ENABLE_TREE_EXPLAIN
SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION
SQLITE_ENABLE_UNLOCK_NOTIFY
SQLITE_ENABLE_UPDATE_DELETE_LIMIT
SQLITE_ERROR
SQLITE_EXTRA_DURABLE
SQLITE_FAIL
SQLITE_FCNTL_BUSYHANDLER
SQLITE_FCNTL_CHUNK_SIZE
SQLITE_FCNTL_COMMIT_PHASETWO
SQLITE_FCNTL_FILE_POINTER
SQLITE_FCNTL_GET_LOCKPROXYFILE
SQLITE_FCNTL_HAS_MOVED
SQLITE_FCNTL_JOURNAL_POINTER
SQLITE_FCNTL_LAST_ERRNO
SQLITE_FCNTL_LOCKSTATE
SQLITE_FCNTL_MMAP_SIZE
SQLITE_FCNTL_OVERWRITE
SQLITE_FCNTL_PDB
SQLITE_FCNTL_PERSIST_WAL
SQLITE_FCNTL_POWERSAFE_OVERWRITE
SQLITE_FCNTL_PRAGMA
SQLITE_FCNTL_RBU
SQLITE_FCNTL_SET_LOCKPROXYFILE
SQLITE_FCNTL_SIZE_HINT
SQLITE_FCNTL_SYNC
SQLITE_FCNTL_SYNC_OMITTED
SQLITE_FCNTL_TEMPFILENAME
SQLITE_FCNTL_TRACE
SQLITE_FCNTL_VFS_POINTER
SQLITE_FCNTL_VFSNAME
SQLITE_FCNTL_WAL_BLOCK
SQLITE_FCNTL_WIN32_AV_RETRY
SQLITE_FCNTL_WIN32_GET_HANDLE
SQLITE_FCNTL_WIN32_SET_HANDLE
SQLITE_FCNTL_ZIPVFS
SQLITE_FLOAT
SQLITE_FORMAT
SQLITE_FTS3_MAX_EXPR_DEPTH
SQLITE_FULL
SQLITE_FUNCTION
SQLITE_HAVE_ISNAN
SQLITE_IGNORE
SQLITE_INDEX_CONSTRAINT_EQ
SQLITE_INDEX_CONSTRAINT_GE
SQLITE_INDEX_CONSTRAINT_GLOB
SQLITE_INDEX_CONSTRAINT_GT
SQLITE_INDEX_CONSTRAINT_LE
SQLITE_INDEX_CONSTRAINT_LIKE
SQLITE_INDEX_CONSTRAINT_LT
SQLITE_INDEX_CONSTRAINT_MATCH
SQLITE_INDEX_CONSTRAINT_REGEXP
SQLITE_INDEX_SCAN_UNIQUE
SQLITE_INSERT
sqlite_int64
SQLITE_INTEGER
SQLITE_INTERNAL
SQLITE_INTERRUPT
SQLITE_IOCAP_ATOMIC
SQLITE_IOCAP_ATOMIC16K
SQLITE_IOCAP_ATOMIC1K
SQLITE_IOCAP_ATOMIC2K
SQLITE_IOCAP_ATOMIC32K
SQLITE_IOCAP_ATOMIC4K
SQLITE_IOCAP_ATOMIC512
SQLITE_IOCAP_ATOMIC64K
SQLITE_IOCAP_ATOMIC8K
SQLITE_IOCAP_IMMUTABLE
SQLITE_IOCAP_POWERSAFE_OVERWRITE
SQLITE_IOCAP_SAFE_APPEND
SQLITE_IOCAP_SEQUENTIAL
SQLITE_IOCAP_UNDELETABLE_WHEN_OPEN
SQLITE_IOERR
SQLITE_IOERR_ACCESS
SQLITE_IOERR_AUTH
SQLITE_IOERR_BLOCKED
SQLITE_IOERR_CHECKRESERVEDLOCK
SQLITE_IOERR_CLOSE
SQLITE_IOERR_CONVPATH
SQLITE_IOERR_DELETE
SQLITE_IOERR_DELETE_NOENT
SQLITE_IOERR_DIR_CLOSE
SQLITE_IOERR_DIR_FSYNC
SQLITE_IOERR_FSTAT
SQLITE_IOERR_FSYNC
SQLITE_IOERR_GETTEMPPATH
SQLITE_IOERR_LOCK
SQLITE_IOERR_MMAP
SQLITE_IOERR_NOMEM
SQLITE_IOERR_RDLOCK
SQLITE_IOERR_READ
SQLITE_IOERR_SEEK
SQLITE_IOERR_SHMLOCK
SQLITE_IOERR_SHMMAP
SQLITE_IOERR_SHMOPEN
SQLITE_IOERR_SHMSIZE
SQLITE_IOERR_SHORT_READ
SQLITE_IOERR_TRUNCATE
SQLITE_IOERR_UNLOCK
SQLITE_IOERR_VNODE
SQLITE_IOERR_WRITE
SQLITE_LIKE_DOESNT_MATCH_BLOBS
SQLITE_LIMIT_ATTACHED
SQLITE_LIMIT_COLUMN
SQLITE_LIMIT_COMPOUND_SELECT
SQLITE_LIMIT_EXPR_DEPTH
SQLITE_LIMIT_FUNCTION_ARG
SQLITE_LIMIT_LENGTH
SQLITE_LIMIT_LIKE_PATTERN_LENGTH
SQLITE_LIMIT_SQL_LENGTH
SQLITE_LIMIT_TRIGGER_DEPTH
SQLITE_LIMIT_VARIABLE_NUMBER
SQLITE_LIMIT_VDBE_OP
SQLITE_LIMIT_WORKER_THREADS
SQLITE_LOCK_EXCLUSIVE
SQLITE_LOCK_NONE
SQLITE_LOCK_PENDING
SQLITE_LOCK_RESERVED
SQLITE_LOCK_SHARED
SQLITE_LOCKED
SQLITE_LOCKED_SHAREDCACHE
sqlite_master
sqlite_master table
SQLITE_MAX_ATTACHED
SQLITE_MAX_COLUMN
SQLITE_MAX_COMPOUND_SELECT
SQLITE_MAX_EXPR_DEPTH
SQLITE_MAX_FUNCTION_ARG
SQLITE_MAX_LENGTH
SQLITE_MAX_LIKE_PATTERN_LENGTH
SQLITE_MAX_MEMORY
SQLITE_MAX_MMAP_SIZE
SQLITE_MAX_PAGE_COUNT
SQLITE_MAX_SCHEMA_RETRY
SQLITE_MAX_SQL_LENGTH
SQLITE_MAX_TRIGGER_DEPTH
SQLITE_MAX_VARIABLE_NUMBER
SQLITE_MAX_WORKER_THREADS
SQLITE_MEMDEBUG
SQLITE_MINIMUM_FILE_DESCRIPTOR
SQLITE_MISMATCH
SQLITE_MISUSE
SQLITE_MUTEX_FAST
SQLITE_MUTEX_RECURSIVE
SQLITE_MUTEX_STATIC_APP1
SQLITE_MUTEX_STATIC_APP2
SQLITE_MUTEX_STATIC_APP3
SQLITE_MUTEX_STATIC_LRU
SQLITE_MUTEX_STATIC_LRU2
SQLITE_MUTEX_STATIC_MASTER
SQLITE_MUTEX_STATIC_MEM
SQLITE_MUTEX_STATIC_MEM2
SQLITE_MUTEX_STATIC_OPEN
SQLITE_MUTEX_STATIC_PMEM
SQLITE_MUTEX_STATIC_PRNG
SQLITE_MUTEX_STATIC_VFS1
SQLITE_MUTEX_STATIC_VFS2
SQLITE_MUTEX_STATIC_VFS3
SQLITE_NOLFS
SQLITE_NOMEM
SQLITE_NOTADB
SQLITE_NOTFOUND
SQLITE_NOTICE
SQLITE_NOTICE_RECOVER_ROLLBACK
SQLITE_NOTICE_RECOVER_WAL
SQLITE_NULL
SQLITE_OK
SQLITE_OK_LOAD_PERMANENTLY
SQLITE_OMIT_ALTERTABLE
SQLITE_OMIT_ANALYZE
SQLITE_OMIT_ATTACH
SQLITE_OMIT_AUTHORIZATION
SQLITE_OMIT_AUTOINCREMENT
SQLITE_OMIT_AUTOINIT
SQLITE_OMIT_AUTOMATIC_INDEX
SQLITE_OMIT_AUTORESET
SQLITE_OMIT_AUTOVACUUM
SQLITE_OMIT_BETWEEN_OPTIMIZATION
SQLITE_OMIT_BLOB_LITERAL
SQLITE_OMIT_BTREECOUNT
SQLITE_OMIT_BUILTIN_TEST
SQLITE_OMIT_CAST
SQLITE_OMIT_CHECK
SQLITE_OMIT_COMPILEOPTION_DIAGS
SQLITE_OMIT_COMPLETE
SQLITE_OMIT_COMPOUND_SELECT
SQLITE_OMIT_CTE
SQLITE_OMIT_DATETIME_FUNCS
SQLITE_OMIT_DECLTYPE
SQLITE_OMIT_DEPRECATED
SQLITE_OMIT_DISKIO
SQLITE_OMIT_EXPLAIN
SQLITE_OMIT_FLAG_PRAGMAS
SQLITE_OMIT_FLOATING_POINT
SQLITE_OMIT_FOREIGN_KEY
SQLITE_OMIT_GET_TABLE
SQLITE_OMIT_INCRBLOB
SQLITE_OMIT_INTEGRITY_CHECK
SQLITE_OMIT_LIKE_OPTIMIZATION
SQLITE_OMIT_LOAD_EXTENSION
SQLITE_OMIT_LOCALTIME
SQLITE_OMIT_LOOKASIDE
SQLITE_OMIT_MEMORYDB
SQLITE_OMIT_OR_OPTIMIZATION
SQLITE_OMIT_PAGER_PRAGMAS
SQLITE_OMIT_PRAGMA
SQLITE_OMIT_PROGRESS_CALLBACK
SQLITE_OMIT_QUICKBALANCE
SQLITE_OMIT_REINDEX
SQLITE_OMIT_SCHEMA_PRAGMAS
SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS
SQLITE_OMIT_SHARED_CACHE
SQLITE_OMIT_SUBQUERY
SQLITE_OMIT_TCL_VARIABLE
SQLITE_OMIT_TEMPDB
SQLITE_OMIT_TRACE
SQLITE_OMIT_TRIGGER
SQLITE_OMIT_TRUNCATE_OPTIMIZATION
SQLITE_OMIT_UTF16
SQLITE_OMIT_VACUUM
SQLITE_OMIT_VIEW
SQLITE_OMIT_VIRTUALTABLE
SQLITE_OMIT_WAL
SQLITE_OMIT_WSD
SQLITE_OMIT_XFER_OPT
SQLITE_OPEN_AUTOPROXY
SQLITE_OPEN_CREATE
SQLITE_OPEN_DELETEONCLOSE
SQLITE_OPEN_EXCLUSIVE
SQLITE_OPEN_FULLMUTEX
SQLITE_OPEN_MAIN_DB
SQLITE_OPEN_MAIN_JOURNAL
SQLITE_OPEN_MASTER_JOURNAL
SQLITE_OPEN_MEMORY
SQLITE_OPEN_NOMUTEX
SQLITE_OPEN_PRIVATECACHE
SQLITE_OPEN_READONLY
SQLITE_OPEN_READWRITE
SQLITE_OPEN_SHAREDCACHE
SQLITE_OPEN_SUBJOURNAL
SQLITE_OPEN_TEMP_DB
SQLITE_OPEN_TEMP_JOURNAL
SQLITE_OPEN_TRANSIENT_DB
SQLITE_OPEN_URI
SQLITE_OPEN_WAL
SQLITE_OS_OTHER
SQLITE_PERM
SQLITE_POWERSAFE_OVERWRITE
SQLITE_PRAGMA
SQLITE_PROTOCOL
SQLITE_RANGE
SQLITE_READ
SQLITE_READONLY
SQLITE_READONLY_CANTLOCK
SQLITE_READONLY_DBMOVED
SQLITE_READONLY_RECOVERY
SQLITE_READONLY_ROLLBACK
SQLITE_RECURSIVE
SQLITE_REINDEX
SQLITE_REPLACE
SQLITE_REVERSE_UNORDERED_SELECTS
SQLITE_ROLLBACK
SQLITE_ROW
SQLITE_RTREE_INT_ONLY
SQLITE_SAVEPOINT
SQLITE_SCANSTAT_EST
SQLITE_SCANSTAT_EXPLAIN
SQLITE_SCANSTAT_NAME
SQLITE_SCANSTAT_NLOOP
SQLITE_SCANSTAT_NVISIT
SQLITE_SCANSTAT_SELECTID
SQLITE_SCHEMA
SQLITE_SECURE_DELETE
SQLITE_SELECT
sqlite_sequence
SQLITE_SHM_EXCLUSIVE
SQLITE_SHM_LOCK
SQLITE_SHM_NLOCK
SQLITE_SHM_SHARED
SQLITE_SHM_UNLOCK
SQLITE_SORTER_PMASZ
SQLITE_SOUNDEX
SQLITE_SOURCE_ID
sqlite_source_id() SQL function
sqlite_stat1
sqlite_stat2
sqlite_stat3
sqlite_stat4
SQLITE_STATIC
SQLITE_STATUS_MALLOC_COUNT
SQLITE_STATUS_MALLOC_SIZE
SQLITE_STATUS_MEMORY_USED
SQLITE_STATUS_PAGECACHE_OVERFLOW
SQLITE_STATUS_PAGECACHE_SIZE
SQLITE_STATUS_PAGECACHE_USED
SQLITE_STATUS_PARSER_STACK
SQLITE_STATUS_SCRATCH_OVERFLOW
SQLITE_STATUS_SCRATCH_SIZE
SQLITE_STATUS_SCRATCH_USED
SQLITE_STMTJRNL_SPILL
SQLITE_STMTSTATUS counter
SQLITE_STMTSTATUS_AUTOINDEX
SQLITE_STMTSTATUS_FULLSCAN_STEP
SQLITE_STMTSTATUS_SORT
SQLITE_STMTSTATUS_VM_STEP
SQLITE_SYNC_DATAONLY
SQLITE_SYNC_FULL
SQLITE_SYNC_NORMAL
SQLITE_SYSCALL
SQLITE_TCLAPI
SQLITE_TEMP_STORE
SQLITE_TESTCTRL_ALWAYS
SQLITE_TESTCTRL_ASSERT
SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS
SQLITE_TESTCTRL_BITVEC_TEST
SQLITE_TESTCTRL_BYTEORDER
SQLITE_TESTCTRL_EXPLAIN_STMT
SQLITE_TESTCTRL_FAULT_INSTALL
SQLITE_TESTCTRL_FIRST
SQLITE_TESTCTRL_IMPOSTER
SQLITE_TESTCTRL_ISINIT
SQLITE_TESTCTRL_ISKEYWORD
SQLITE_TESTCTRL_LAST
SQLITE_TESTCTRL_LOCALTIME_FAULT
SQLITE_TESTCTRL_NEVER_CORRUPT
SQLITE_TESTCTRL_ONCE_RESET_THRESHOLD
SQLITE_TESTCTRL_OPTIMIZATIONS
SQLITE_TESTCTRL_PENDING_BYTE
SQLITE_TESTCTRL_PRNG_RESET
SQLITE_TESTCTRL_PRNG_RESTORE
SQLITE_TESTCTRL_PRNG_SAVE
SQLITE_TESTCTRL_RESERVE
SQLITE_TESTCTRL_SCRATCHMALLOC
SQLITE_TESTCTRL_SORTER_MMAP
SQLITE_TESTCTRL_VDBE_COVERAGE
SQLITE_TEXT
SQLITE_THREADSAFE
SQLITE_TOOBIG
SQLITE_TRACE
SQLITE_TRACE_CLOSE
SQLITE_TRACE_PROFILE
SQLITE_TRACE_ROW
SQLITE_TRACE_SIZE_LIMIT
SQLITE_TRACE_STMT
SQLITE_TRANSACTION
SQLITE_TRANSIENT
sqlite_uint64
SQLITE_UNTESTABLE
SQLITE_UPDATE
SQLITE_USE_FCNTL_TRACE
SQLITE_USE_URI
SQLITE_UTF16
SQLITE_UTF16_ALIGNED
SQLITE_UTF16BE
SQLITE_UTF16LE
SQLITE_UTF8
SQLITE_VERSION
sqlite_version() SQL function
SQLITE_VERSION_NUMBER
SQLITE_VTAB_CONSTRAINT_SUPPORT
SQLITE_WARNING
SQLITE_WARNING_AUTOINDEX
SQLITE_WIN32_HEAP_CREATE
SQLITE_WIN32_MALLOC
SQLITE_WIN32_MALLOC_VALIDATE
SQLITE_ZERO_MALLOC
standard query parameters
statement journal
stats pragma
status method
status parameters
storage class
strategies
strftime() SQL function
subprograms
Subqueries
substr() SQL function
sum() aggregate function
synchronous pragma
syntax diagrams
table-constraint
table-constraint syntax diagram
table-or-subquery
table-or-subquery syntax diagram
table-valued function
table-valued functions in the FROM clause
table_info pragma
Tcl extension
TCL Interface
TCL interface authorizer method
TCL interface backup method
TCL interface busy method
TCL interface cache method
TCL interface changes method
TCL interface close method
TCL interface collate method
TCL interface collation_needed method
TCL interface commit_hook method
TCL interface complete method
TCL interface copy method
TCL interface enable_load_extension method
TCL interface errorcode method
TCL interface eval method
TCL interface exists method
TCL interface function method
TCL interface incrblob method
TCL interface last_insert_rowid method
TCL interface nullvalue method
TCL interface onecolumn method
TCL interface profile method
TCL interface progress method
TCL interface restore method
TCL interface rollback_hook method
TCL interface status method
TCL interface timeout method
TCL interface total_changes method
TCL interface trace method
TCL interface transaction method
TCL interface unlock_notify method
TCL interface update_hook method
TCL interface version method
TCL interface wal_hook method
TCL test suite
TCL variable substitution
TEA tarball
TEMP triggers on non-TEMP tables
temp_store pragma
temp_store_directory pragma
temporary databases
temporary directory search algorithm
temporary disk files
temporary tables
test coverage
test harness
test suite
testcase macros
testing
text encoding
TH3
the .fullschema dot-command
the amalgamation
the ext3 barrier problem
The Fossil NGQP Upgrade Case Study
the json1 extension
the xCachesize() page cache method
the xCreate() page cache methods
the xDestroy() page cache method
the xFetch() page cache methods
the xInit() page cache method
the xPagecount() page cache methods
the xRekey() page cache methods
the xShrink() page cache method
the xShutdown() page cache method
the xUnpin() page cache method
Things That Can Go Wrong
threading mode
threads pragma
three test harnesses
time() SQL function
timeout method
tokenizer
torn page
total() aggregate function
total_changes method
total_changes() SQL function
trace method
transaction method
transactional
treats the CROSS JOIN operator specially
trim() SQL function
truncate optimization
type affinity
type-name
type-name syntax diagram
typeof() SQL function
undefined BEFORE trigger behavior
undo/redo
unicode() SQL function
unicode61
Uniform Resource Identifier
unindexed
UNIQUE
unique constraint
unique index
unlikely() SQL function
unlink corruption
unlinked database files
unlock_notify method
unprotected sqlite3_value
UPDATE
update-stmt
update-stmt syntax diagram
update-stmt-limited
update-stmt-limited syntax diagram
update_hook method
upper() SQL function
URI
URI filename
URI filename examples
URI filenames in sqlite3_open()
URI query parameters
usable size
user_version pragma
using SQLite for websites
Using the SQLite Online Backup API
Using the SQLite Unlock Notification Feature
'utc' modifier
VACUUM
vacuum-stmt
vacuum-stmt syntax diagram
VALUES
VALUES clause
variable-length integer
varint
VDBE
vdbe_addoptrace pragma
vdbe_debug pragma
vdbe_listing pragma
vdbe_trace pragma
vectors
Version 3.0.0
Version 3.0.1
Version 3.0.2
Version 3.0.3
Version 3.0.4
Version 3.0.5
Version 3.0.6
Version 3.0.7
Version 3.0.8
Version 3.1.0
Version 3.1.1
Version 3.1.2
Version 3.1.3
Version 3.1.4
Version 3.1.5
Version 3.1.6
Version 3.10.0
Version 3.10.1
Version 3.10.2
Version 3.11.0
Version 3.11.1
Version 3.12.0
version 3.12.0 page size change
Version 3.12.1
Version 3.12.2
Version 3.13.0
Version 3.13.0.0
Version 3.14
Version 3.14.0
Version 3.14.1
Version 3.14.2
Version 3.15.0
Version 3.15.1
Version 3.15.2
Version 3.16.0
Version 3.16.1
Version 3.16.2
Version 3.17.0
Version 3.18.0
Version 3.19.0
Version 3.19.1
Version 3.19.2
Version 3.19.3
Version 3.2.0
Version 3.2.1
Version 3.2.2
Version 3.2.3
Version 3.2.4
Version 3.2.5
Version 3.2.6
Version 3.2.7
Version 3.2.8
Version 3.3.0
Version 3.3.0.0
Version 3.3.1
Version 3.3.1.0
Version 3.3.10
Version 3.3.10.0
Version 3.3.11
Version 3.3.11.0
Version 3.3.12
Version 3.3.12.0
Version 3.3.13
Version 3.3.13.0
Version 3.3.14
Version 3.3.14.0
Version 3.3.15
Version 3.3.15.0
Version 3.3.16
Version 3.3.16.0
Version 3.3.17
Version 3.3.17.0
Version 3.3.2
Version 3.3.2.0
Version 3.3.3
Version 3.3.3.0
Version 3.3.4
Version 3.3.4.0
Version 3.3.5
Version 3.3.5.0
Version 3.3.6
Version 3.3.6.0
Version 3.3.7
Version 3.3.7.0
Version 3.3.8
Version 3.3.8.0
Version 3.3.9
Version 3.3.9.0
Version 3.4.0
Version 3.4.1
Version 3.4.2
Version 3.5.0
Version 3.5.1
Version 3.5.2
Version 3.5.3
Version 3.5.4
Version 3.5.5
Version 3.5.6
Version 3.5.7
Version 3.5.8
Version 3.5.9
Version 3.6.0
Version 3.6.1
Version 3.6.10
Version 3.6.11
Version 3.6.12
Version 3.6.13
Version 3.6.14
Version 3.6.14.1
Version 3.6.14.2
Version 3.6.15
Version 3.6.16
Version 3.6.16.1
Version 3.6.17
Version 3.6.18
Version 3.6.19
Version 3.6.2
Version 3.6.20
Version 3.6.21
Version 3.6.22
Version 3.6.23
Version 3.6.23.1
Version 3.6.23.1.0
Version 3.6.3
Version 3.6.4
Version 3.6.5
Version 3.6.6
Version 3.6.6.1
Version 3.6.6.2
Version 3.6.7
Version 3.6.8
Version 3.6.9
Version 3.7.0
Version 3.7.0.1
Version 3.7.1
Version 3.7.10
Version 3.7.11
Version 3.7.12
Version 3.7.12.1
Version 3.7.13
Version 3.7.14
Version 3.7.14.1
Version 3.7.15
Version 3.7.15.1
Version 3.7.15.2
Version 3.7.16
Version 3.7.16.1
Version 3.7.16.2
Version 3.7.17
Version 3.7.2
Version 3.7.3
Version 3.7.4
Version 3.7.5
Version 3.7.6
Version 3.7.6.1
Version 3.7.6.2
Version 3.7.6.3
Version 3.7.7
Version 3.7.7.1
Version 3.7.8
Version 3.7.9
Version 3.8.0
Version 3.8.0.1
Version 3.8.0.2
Version 3.8.1
Version 3.8.10
Version 3.8.10.1
Version 3.8.10.2
Version 3.8.11
Version 3.8.11.1
Version 3.8.2
Version 3.8.3
Version 3.8.3.1
Version 3.8.3.1.0
Version 3.8.4
Version 3.8.4.1
Version 3.8.4.2
Version 3.8.4.3
Version 3.8.5
Version 3.8.6
Version 3.8.7
Version 3.8.7.1
Version 3.8.7.2
Version 3.8.7.3
Version 3.8.7.4
Version 3.8.8
Version 3.8.8.1
Version 3.8.8.2
Version 3.8.8.3
Version 3.8.9
Version 3.9.0
Version 3.9.1
Version 3.9.2
Version 3.9.3
version method
version numbering conventions
version-valid-for number
VFS
VFS shims
"vfs" query parameter
VFSes
view
virtual machine
virtual machine instructions
virtual table
virtual table cursor
virtual table module
WAL
WAL backwards compatibility
WAL checksum algorithm
WAL concurrency
WAL format
WAL mode
WAL read algorithm
WAL without shared memory
wal-index
WAL-index format
WAL-mode read blocking
wal_autocheckpoint pragma
wal_checkpoint pragma
wal_hook method
What If OpenOffice Used SQLite
when to use WITHOUT ROWID
WHERE clause
Win32 native memory allocator
WITH
WITH clause
with-clause
with-clause syntax diagram
WITHOUT rowid
WITHOUT ROWID virtual tables
writable_schema pragma
write-ahead log
writer starvation
xBegin
xBestIndex
xColumn
xCommit
xConnect
xCreate
xDestroy
xDisconnect
xEof
xFilter
xFindFunction
xNext
xQueryFunc R*Tree callback
xRelease
xRename
xRollback
xRollbackTo
xRowid
xSavepoint
xUpdate
YYSTACKDEPTH
YYTRACKMAXSTACKDEPTH
zero-configuration
zero-malloc memory allocator
zeroblob() SQL function