Small. Fast. Reliable.
Choose any three.
Choose any three.
|
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 ...
|
|
DROP VIEW
(lang_dropview.html)
The DROP VIEW statement removes a view created by the CREATE VIEW
statement. The view definition is removed from the database schema, but
no actual data in the underlying base tables is modified.
The view to drop is identified by ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
14. Automatic Query-Time Indexes
... CREATE TABLE t1(a,b);
CREATE TABLE t2(c,d);
-- Insert many rows into both t1 and t2
SELECT a, (SELECT d FROM t2 WHERE c=b) FROM t1;
In this example, the t2 table is used in a subquery ...
|
|
Command Line Shell For SQLite
(cli.html)
16. Index Recommendations (SQLite Expert)
... sqlite> CREATE TABLE x1(a, b, c); -- Create table in database
sqlite> .expert
sqlite> SELECT * FROM x1 WHERE a=? AND b>?; -- Analyze this SELECT
CREATE INDEX x1_idx_000123a7 ON x1(a, b);
0|0|0|SEARCH TABLE ...
|
|
The Bytecode() And Tables_Used() Table-Valued Functions
(bytecodevtab.html)
2.1. Schema
The schema of the bytecode table is:
CREATE TABLE bytecode(
addr INT,
opcode TEXT,
p1 INT,
p2 INT,
p3 INT,
p4 TEXT,
p5 INT,
comment TEXT,
subprog TEXT,
stmt HIDDEN
);
The first eight columns are the address, opcode, and operands ...
|
|
The SQLite R*Tree Module
(rtree.html)
3.1. Creating An R*Tree Index
A new R*Tree index is created as follows:
CREATE VIRTUAL TABLE <name> USING rtree(<column-names>);
The <name> is the name your application chooses for the
R*Tree index and <column-names ...
|
|
DROP TABLE
(lang_droptable.html)
The DROP TABLE statement removes a table added with the
CREATE TABLE statement. The name specified is the
table name. The dropped table is completely removed from the database
schema and the disk file. The table can not be recovered ...
|
|
SQLite Database Speed Comparison
(speed.html)
... 25000 INSERTs into an indexed table
BEGIN;
CREATE TABLE t3(a INTEGER, b INTEGER, c VARCHAR(100));
CREATE INDEX i3 ON t3(c);
... 24998 lines omitted
INSERT INTO t3 VALUES(24999,88509,'eighty eight thousand five hundred nine');
INSERT INTO ...
|
|
SQLite Shared-Cache Mode
(sharedcache.html)
2.3. Schema (sqlite_schema) Level Locking
... A connection must obtain a read-lock on sqlite_schema before
accessing any database tables or obtaining any other read or write locks.
Before executing a statement that modifies the database schema (i.e.
a CREATE or DROP TABLE statement), a ...
|
|
C API: Determine The Collation For a Virtual Table Constraint
(c3ref/vtab_collation.html)
sqlite3_vtab_collation()
... If there is no COLLATE operator, but the column that is the subject
of the constraint specifies an alternative collating sequence via
a COLLATE clause on the column definition within the CREATE TABLE
statement that was passed into sqlite3_declare_vtab(), then ...
|
Page generated by FTS5 in about 247.47 ms.