Editing a virtual table

To edit a virtual table:

1. Select the virtual table in the tree panel.

2. Go to the Design tab.

   

3. Make your changes, then click Apply.

Renaming one is done in place: SQLite renames the table and the hidden tables that hold its data together, so nothing is copied and nothing is at risk.

Any other change means a new table. A virtual table's module and its arguments cannot be altered, so SQLite Expert creates a table with the new definition, carries the rows across and drops the old one. Columns are matched by name — one the new definition no longer has is left behind, one it gains arrives empty — and a full-text table that draws on external content has its index rebuilt instead, its rows belonging to another table.

See also: Creating a virtual table · Deleting a virtual table