[sqlite] ParseSchema's virtual machine instructions

Is there a feature (like explain) which returns the sequence of virtual machine instructions that ParseSchema creates? -Mrinal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] pragma table_info on a table in attached db

>As Dennis said, that looks like a bug. Created a new ticket (number 3320: http://www.sqlite.org/cvstrac/tktview?tn=3320) which has been fixed now. - Mrinal. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] pragma table_info on a table in attached db

>Try: >PRAGMA [database.]table_info(table-name); > ( Kees Nuyt Thankyou Kees for the solution But, I am facing another problem which is as follows: I open an sqlite db and create a table "trial". pragma main.table_info(trial) shows correct info. Then I create a temp table with the same name

[sqlite] pragma table_info on a table in attached db

pragma table_info(dbname.tablename) syntax is not allowed. Is there some other way to get the table_info for tables in attached db which bear the same name as another table in either the main, temp or a previously attached db? F.e. I connect to db1.sqlite which contains a table called t1. Then I