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 ...
|
Command Line Shell For SQLite
(cli.html)
17. 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 SQLite Query Optimizer Overview
(optoverview.html)
14. Automatic 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 ...
|
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 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 ...
|
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 ...
|
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 ...
|
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 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 ...
|
SQLite Session Module C/C++ Interface
(session.html)
... Or, if argument zTab is NULL, then changes are recorded for all tables
in the database. If additional tables are added to the database (by
executing "CREATE TABLE" statements) after this call is made, changes for
the new tables are ...
|
Page generated by FTS5 in about 143.93 ms.