Using SQLite

Name

CREATE VIRTUAL TABLE — Create a new virtual table

Syntax

Common Usage

CREATE VIRTUAL TABLE database_name.table_name USING weblog( access.log );
CREATE VIRTUAL TABLE database_name.table_name USING fts3( );

Description

The CREATE VIRTUAL TABLE command creates a virtual table. Virtual tables are data sources that are defined by code and can represent highly optimized data sources or external data sources. The standard SQLite distribution includes virtual table implementations for Full Text Search, as well as an R*Tree-based indexing system.

Virtual tables are covered in detail in Chapter 10.

A virtual table is removed with the standard DROP TABLE command.

See Also

sqlite3_create_module() [C API, Ap G], DROP TABLE