The SQLite Zipfile Module
(zipfile.html)
3.2. Virtual Table Interface (read/write access)
In order to create or modify an existing zip file, a "zipfile" virtual
table must be created in the database schema. The CREATE VIRTUAL TABLE
statement expects a path to the zip file as its only argument. For example, to ...
|
C API: Identify and handle IN constraints in xBestIndex
(c3ref/vtab_in.html)
sqlite3_vtab_in()
This interface may only be used from within an
xBestIndex() method of a virtual table implementation.
The result of invoking this interface from any other context is
undefined and probably harmful.
A constraint on a virtual table of the form ...
|
The SQLite Query Optimizer Overview
(optoverview.html)
7.2. Manual Control Of Query Plans Using SQLITE_STAT Tables
... One method for doing this
is to fudge the ANALYZE results in the sqlite_stat1,
sqlite_stat3, and/or sqlite_stat4 tables. This is not
recommended for most situations.
|
REINDEX
(lang_reindex.html)
... Or, if the argument attached to the REINDEX identifies a specific
database table, then all indices attached to the database table are rebuilt.
If it identifies a specific database index, then just that index is recreated.
For a command of ...
|
C API: Open A BLOB For Incremental I/O
(c3ref/blob_open.html)
sqlite3_blob_open()
This interfaces opens a handle to the BLOB located
in row iRow, column zColumn, table zTable in database zDb;
in other words, the same BLOB that would be selected by:
SELECT zColumn FROM zDb.zTable WHERE rowid = iRow;
Parameter zDb ...
|
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 ...
|
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 ...
|
Generated Columns
(gencol.html)
2.2. Capabilities
... Generated columns can occur anywhere in the table definition. Generated
columns can be interspersed among ordinary columns. It is not necessary
to put generated columns at the end of the list of columns in the
table definition, as is shown ...
|
SQL Features That SQLite Does Not Implement
(omitted.html)
... Complete ALTER TABLE support
Only the RENAME TABLE, ADD COLUMN, RENAME COLUMN, and DROP COLUMN
variants of the ALTER TABLE command are supported. Other kinds of
ALTER TABLE operations such as
ALTER COLUMN, ADD CONSTRAINT, and so forth are ...
|
The sqlite3_analyzer.exe Utility Program
(sqlanalyze.html)
1.2. Example Output
... Number of tables in the database
The number of tables in the database, including the SQLITE_SCHEMA table
used to store schema information.
Number of indices
The total number of indices in the database.
Number of defined indices
The number of ...
|
Page generated by FTS5 in about 153.60 ms.