SQLITE_INDEX_SCAN_UNIQUE

Virtual table implementations are allowed to set the sqlite3_index_info.idxFlags field to some combination of these bits. See also lists of Objects, Constants, and Functions.

sqlite3_declare_vtab()

The xCreate and xConnect methods of a virtual table module call this interface to declare the format (the names and datatypes of the columns) of the virtual tables they implement. See also lists of Objects, Constants, and Functions.

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

sqlite3_vtab_on_conflict()

This function may only be called from within a call to the xUpdate method of a virtual table implementation for an INSERT or UPDATE operation. The value returned is one of SQLITE_ROLLBACK, SQLITE_IGNORE, SQLITE_FAIL, SQLITE_ABORT, or SQLITE_REPLACE, according to the ... 

sqlite3_drop_modules()

The sqlite3_drop_modules(D,L) interface removes all virtual table modules from database connection D except those named on list L. The L parameter must be either NULL or a pointer to an array of pointers to strings where the array ... 

sqlite3_vtab_config()

This function may be called by either the xConnect or xCreate method of a virtual table implementation to configure various facets of the virtual table interface. If this interface is invoked outside the context of an xConnect or xCreate virtual ... 

A virtual table is an interface to an external storage or computation engine that appears to be a table but does not actually store information in the database file. In general, you can do anything with a virtual table that ... 

struct sqlite3_module

This structure, sometimes called a "virtual table module", defines the implementation of a virtual table. This structure consists mostly of methods for the module. A virtual table module is created by filling in a persistent instance of this structure and ... 

struct sqlite3_vtab_cursor

Every virtual table module implementation uses a subclass of the following structure to describe cursors that point into the virtual table and are used to loop through the virtual table. Cursors are created using the xOpen method of the module ... 

sqlite3_overload_function()

Virtual tables can provide alternative implementations of functions using the xFindFunction method of the virtual table module. But global versions of those functions must exist in order to be overloaded. This API makes sure a global version of a function ...