Editing virtual tables

A virtual table looks and behaves like an ordinary table when you query it, but its data is supplied by a module rather than stored in the usual way. SQLite ships with several modules — full-text search (FTS3, FTS4, FTS5), R-Tree spatial indexes, and CSV access among them — and extensions can add more. SQLite Expert lets you create and manage virtual tables visually.

In this section

• Creating a virtual table
• Editing a virtual table
• Renaming a virtual table
• Deleting a virtual table