[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 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 "trial". Now, pragma main.table_info(trial) shows the info about the temp table. pragma temp.table_info(trial) also shows info about the temp table. How do I get the table_info of the main.trial in this case? sqlite3.exe trial.sqlite SQLite version 3.5.2 Enter ".help" for instructions sqlite> create table trial (col_main); sqlite> pragma main.table_info(trial); 0|col_main||0||0 sqlite> create temp table trial (col_temp); sqlite> pragma main.table_info(trial); 0|col_temp||0||0 sqlite> pragma temp.table_info(trial); 0|col_temp||0||0 sqlite> - Mrinal. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 attach db2.sqlite (as db2) which also contains a table called t1. Using pragma table_info(t1) returns info about the t1 in db1.sqlite Using pragma table_info(db2.t1) returns error Is there a solution? Or is it planned in some future version? Thanks, Mrinal. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users