sqlite introspection error

[therealcorwin]

When i drop a table on sqlite database, i have this error. When i check the table with another vscode addon the table is correctly dropped.

LOG :

2025-11-09 19:11:50.696 [error] Connection: introspection of 'main' on 'plop' error: no such table: main.charge

Error:
no such table: main.charge

---

VSCode Version: 1.105.1
Extension Version: 1.17.32
OS: win32
Arch: x64
Database Version: 3.50.4 - 3.50.4

[mikeburgh]

I think the issue you are finding is there is a view that was using that table.. and SQLite then breaks when I try to get the columns of that view…

There is some discussion about it here:
https://sqlite.org/forum/info/4c148b745a5c92b0fbd21283f467dee644508f25413bcf7bf2105d1aed252601

I have released version 1.17.33 which will work around this and show a warning if it finds views without backing tables.. and while that condition exists, views wont show columns.

[therealcorwin]

Thx :) Your workaround works well ^_^