Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The UNION Virtual Table
(unionvtab.html)
... All tables that participate in a union-vtab must have identical
CREATE TABLE definitions, except that the names of the tables can be different.
All tables that participate in a union-vtab must be rowid tables.
The column names and ...
|
|
Query Language Understood by SQLite
(lang.html)
... aggregate functions
ALTER TABLE
ANALYZE
ATTACH DATABASE
BEGIN TRANSACTION
comment
COMMIT TRANSACTION
core functions
CREATE INDEX
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
CREATE VIRTUAL TABLE
date and time functions
DELETE
DETACH DATABASE
DROP INDEX
DROP TABLE
DROP TRIGGER
DROP VIEW ...
|
|
C API: Register A Virtual Table Implementation
(c3ref/create_module.html)
sqlite3_create_module(), sqlite3_create_module_v2()
These routines are used to register a new virtual table module name.
Module names must be registered before
creating a new virtual table using the module and before using a
preexisting virtual table for the module.
The module name is ...
|
|
The RBU Extension
(rbu.html)
2.2.3. Using RBU with FTS3/4 Tables
Usually, an FTS3 or FTS4 table is an example of a virtual table
with a rowid that works like a PRIMARY KEY. So, for the following FTS4 tables:
CREATE VIRTUAL TABLE ft1 USING fts4(addr, text);
CREATE VIRTUAL TABLE ft2 ...
|
|
SQLite Autoincrement
(autoinc.html)
2. Background
... The usual algorithm is to give the newly created row
a ROWID that is one larger than the largest ROWID in the table prior
to the insert. If the table is initially empty, then a ROWID of 1 is
used ...
|
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
1.1. Syntax
To create a WITHOUT ROWID table, simply add the keywords "WITHOUT ROWID"
to the end of the CREATE TABLE statement. For example:
CREATE TABLE IF NOT EXISTS wordcount(
word TEXT PRIMARY KEY,
cnt INTEGER
) WITHOUT ROWID;
As with all SQL ...
|
|
SQLite FTS5 Extension
(fts5.html)
Changes to CREATE VIRTUAL TABLE statements
... There is as of yet no equivalent for their functionality.
-- FTS3/4 statement
CREATE VIRTUAL TABLE t1 USING fts4(
linkid INTEGER,
header CHAR(20),
text VARCHAR,
notindexed=linkid,
matchinfo=fts3,
tokenizer=unicode61
);
-- FTS5 equivalent (note - the "tokenizer=unicode61" option is ...
|
|
Partial Indexes
(partialindex.html)
2. Creating Partial Indexes
... Indexes that omit the WHERE clause (or indexes that
are created by UNIQUE or PRIMARY KEY constraints inside of CREATE TABLE
statements) are ordinary full indexes.
The expression following the WHERE clause may contain operators,
literal values, and names of ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
1.2. Creating and Destroying FTS Tables
Like other virtual table types, new FTS tables are created using a
CREATE VIRTUAL TABLE statement. The module name, which follows
the USING keyword, is either "fts3" or "fts4". The virtual table module arguments may
be left empty, in which ...
|
|
The CSV Virtual Table
(csv.html)
1. Overview
... The CSV virtual table is usually
created as a TEMP table so that it exists only for the current database
connection and does not become a permanent part of the database schema.
Note that there is no "CREATE TEMP VIRTUAL ...
|
Page generated by FTS5 in about 141.65 ms.