Imposter Tables

1. Introduction

An imposter table is a table that is attached to the same b-tree as an index. An imposter table allows the content of an index to be queried or modified as if the index were an ordinary table.

Imposter tables are intended for analysis and debugging only. This is not a feature that most application developers should understand or even know about. Imposter tables are for experts only.

Improper use of imposter tables can cause index corruption, though any corruption created this way can be fixed by running REINDEX-

2. Details

Each table and each index in SQLite is stored in a separate b-tree in the database file. Each b-tree is identified by its root page number. The root page number for any index or table can be found by

登录查看完整内容