vendredi 1 mai 2015

How do you extract all the tokens in a SQLite FTS table?

For debugging purposes I want to see all the tokens that exist in a Full Text Search virtual table in SQLite.

When I look at the database structure for my FTS table (named fts_table) I see the following:

enter image description here

But browsing the data in these tables doesn't show the the list of tokens (not that I can find, anyway).

How do I extract a simple list of tokens?

Aucun commentaire:

Enregistrer un commentaire