On Tue, 19 Aug 2008 01:14:43 +0530, Mrinal wrote: >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?
Try: PRAGMA [database.]table_info(table-name); Most other databse specific PRAGMAs support the databasealias. prefix, so does this one, although it isn't documented in http://www.sqlite.org/pragma.html#schema . >Thanks, >Mrinal. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
