Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... For example, a DROP TABLE statement cannot be run while another thread
is reading from that table on the same database connection because
dropping the table would delete the table out from under the concurrent
reader.
The SQLITE_LOCKED result code ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
1.2. Creating and Destroying FTS Tables
... For example:
-- Create, then immediately drop, an FTS4 table.
CREATE VIRTUAL TABLE data USING fts4();
DROP TABLE data;
|
|
CREATE TABLE
(lang_createtable.html)
... Tables are removed using the DROP TABLE statement.
2.1. CREATE TABLE ... AS SELECT Statements
A "CREATE TABLE ... AS SELECT" statement creates and populates a database
table based on the results of a SELECT statement. The table has the same ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... But rows that are
deleted because of a DROP TABLE are not counted.
SQLite implements the command "DELETE FROM table" (without
a WHERE clause) by dropping the table then recreating it.
This is much faster than deleting the elements of ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... If no page movement was required (because the
table being dropped was already the last one in the database) then a
zero is stored in register P2. If AUTOVACUUM is disabled then a zero
is stored in register P2.
This ...
|
|
How To Corrupt An SQLite Database File
(howtocorrupt.html)
2.2. Posix advisory locks canceled by a separate thread doing close()
... But the close() system call caused the
locks held on the database by all the other threads to be dropped. Those
other threads have no way of knowing that their locks have just been
trashed (POSIX does not provide any ...
|
|
The SQLite R*Tree Module
(rtree.html)
3.1. Creating An R*Tree Index
... And you can UPDATE, DELETE, INSERT or even DROP
the shadow tables, though doing so will corrupt your R*Tree index.
So it is best to simply ignore the shadow tables. Recognize that they
hold your R*Tree index information ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.5. The xDestroy Method
... The xDestroy method is only
called when a DROP TABLE statement is executed against the virtual table.
The xDestroy method is required for every virtual table implementation,
though it is acceptable for the xDisconnect and xDestroy methods to be
the ...
|
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... Restrictions on the use of the same database connection by multiple
threads have been dropped. It is now safe for
multiple threads to use the same database connection at the same
time.
There is now a compile-time option that ...
|
|
The Next-Generation Query Planner
(queryplanner-ng.html)
2.2. The SQLite Query Planner Stability Guarantee
... the database schema does not change in significant ways such as
adding or dropping indexes,
the ANALYZE command is not rerun,
the same version of SQLite is used.
The QPSG is disabled by default. It can be enabled at compile ...
|
Page generated by FTS5 in about 51.55 ms.