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

Reply via email to