Small. Fast. Reliable.
Choose any three.
CREATE VIRTUAL TABLE

create-virtual-table-stmt:

CREATE VIRTUAL TABLE IF NOT EXISTS schema-name . table-name USING module-name ( module-argument ) ,

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 can be done with an ordinary table, except that R-49065-33371:[you cannot create indices or triggers on a virtual table. ] R-29387-20242:[Some virtual table implementations might impose additional restrictions. ] For example, many virtual tables are read-only.

The module-name is the name of an object that implements the virtual table. R-06962-29571:[The module-name must be registered with the SQLite database connection using sqlite3_create_module() or sqlite3_create_module_v2() prior to issuing the CREATE VIRTUAL TABLE statement. ] R-56921-36726:[The module takes zero or more comma-separated arguments. ] R-36608-10930:[The arguments can be just about any text as long as it has balanced parentheses. ] The argument syntax is sufficiently general that the arguments can be made to appear as column definitions in a traditional CREATE TABLE statement. R-48924-26514:[SQLite passes the module arguments directly to the xCreate and xConnect methods of the module implementation without any interpretation. ] It is the responsibility of the module implementation to parse and interpret its own arguments.

R-63167-05205:[A virtual table is destroyed using the ordinary DROP TABLE statement. ] There is no DROP VIRTUAL TABLE statement.

This page last modified on 2022-01-08 05:02:57 UTC