C API: Virtual Table Scan Flags
(c3ref/c_index_scan_hex.html)
SQLITE_INDEX_SCAN_UNIQUE, SQLITE_INDEX_SCAN_HEX
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.
|
C API: Declare The Schema Of A Virtual Table
(c3ref/declare_vtab.html)
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.
|
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 ...
|
C API: Determine The Virtual Table Conflict Policy
(c3ref/vtab_on_conflict.html)
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 ...
|
C API: Remove Unnecessary Virtual Table Implementations
(c3ref/drop_modules.html)
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 ...
|
CREATE VIRTUAL TABLE
(lang_createvtab.html)
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 ...
|
C API: Virtual Table Interface Configuration
(c3ref/vtab_config.html)
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 ...
|
C API: Virtual Table Object
(c3ref/module.html)
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 ...
|
C API: Virtual Table Cursor Object
(c3ref/vtab_cursor.html)
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 ...
|
C API: Overload A Function For A Virtual Table
(c3ref/overload_function.html)
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 ...
|
Page generated by FTS5 in about 282.88 ms.