Small. Fast. Reliable.
Choose any three.
Choose any three.
|
CREATE VIEW
(lang_createview.html)
... Views are removed
with the DROP VIEW command.
If a column-name list follows
the view-name, then that list determines
the names of the columns for the view. If the column-name
list is omitted, then the names of ...
|
|
SQLite Shared-Cache Mode
(sharedcache.html)
3. Thread Related Issues
... These restrictions were dropped beginning with SQLite
version 3.5.0 (2007-09-04).
|
|
The INDEXED BY Clause
(lang_indexedby.html)
... The intent of the INDEXED BY clause is
to raise a run-time error if a schema change, such as dropping or
creating an index, causes the query plan for a time-sensitive query
to change. The INDEXED BY clause ...
|
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
... In that case,
drop all locks, close the database, and return SQLITE_BUSY.
Read the journal file and roll back the changes.
Wait for the rolled back changes to be written onto
persistent storage. This protects the integrity of the database ...
|
|
CREATE INDEX
(lang_createindex.html)
... Indexes are removed with the DROP INDEX command.
1.1. Unique Indexes
If the UNIQUE keyword appears between CREATE and INDEX then duplicate
index entries are not allowed. Any attempt to insert a duplicate entry
will result in an error ...
|
|
The UNION Virtual Table
(unionvtab.html)
... If the results of query change, then
the union-vtab should be DROP-ed and recreated in order
to cause the query to be run again.
There must be no overlap in the bands of rowids for the various tables ...
|
|
SQLite Keywords
(lang_keywords.html)
... COLUMN
COMMIT
CONFLICT
CONSTRAINT
CREATE
CROSS
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
DATABASE
DEFAULT
DEFERRABLE
DEFERRED
DELETE
DESC
DETACH
DISTINCT
DO
DROP
EACH
ELSE
END
ESCAPE
EXCEPT
EXCLUDE
EXCLUSIVE
EXISTS
EXPLAIN
FAIL
FILTER
FIRST
FOLLOWING
FOR
FOREIGN
FROM
FULL
GENERATED
GLOB
GROUP ...
|
|
SQLite Download Page
(download.html)
... 7dc7203d2081f730a3103498a10253bb9761167afb54f1e8fb64c0f2df522884)
Precompiled Binaries for Android
sqlite-android-3490100.aar(3.40 MiB)
A precompiled Android library containing
the core SQLite together with appropriate Java bindings, ready to drop
into any Android Studio project.(SHA3-256: 664603d2506cfc4c37d4398e760bdcf7c99f983a485469fc135ce52708d2bdc7)
Precompiled Binaries for Linux ...
|
|
Recent SQLite News
(news.html)
... The performance benchmark that
the SQLite developers have used for many years has for
the first time dropped below 1 billion CPU cycles
(measured using cachegrind) when run in WAL mode.
This is less than half the number of CPU ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... The SQLITE_SCHEMA table is automatically updated by commands like
CREATE TABLE, CREATE INDEX, DROP TABLE, and DROP INDEX.
Temporary tables do not appear in the SQLITE_SCHEMA table. Temporary
tables and their indices and triggers occur in another special table
named ...
|
Page generated by FTS5 in about 49.74 ms.