SQLite Forum

Possible bug: pragma table_info(A) does not work, but equivalent select does in preupdate hook
Login
Just out of interest, can you try removing the <code>INSERT</code> commands ?

Then try swapping the order of the <code>CREATE TABLE</code> commands.

PS: As a side comment, SQLite has no <code>VARCHAR</code> type, use <code>TEXT</code> instead.  And use single apostrophes to quote strings, not speech marks.  But these should have no effect on the problem you reported.