Normally, an SQL index references columns of a table. But an index can also be formed on expressions involving table columns. As an example, consider the following table that tracks dollar-amount changes on various "accounts": CREATE TABLE account_change( chng_id ... 

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 ... 

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 ... 

 ... 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 ... 

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 ... 

7.1.1. Manual Control Of Query Plans Using SQLITE_STAT Tables SQLite provides the ability for advanced programmers to exercise control over the query plan chosen by the optimizer. One method for doing this is to fudge the ANALYZE results in the sqlite_stat1 table.

 ... 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 ... 

 ... 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 ... 

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 ... 

PRAGMA table_list PRAGMA table_list; PRAGMA schema.table_list; PRAGMA table_list(table-name); This pragma returns information about the tables and views in the schema, one table per row of output. The table_list pragma first appeared in SQLite version 3.37.0 (2021-11 ...