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