Thank you! On 06/19/2012 08:25 PM, Jay A. Kreibich wrote: > On Tue, Jun 19, 2012 at 08:16:37PM +0200, Patrik Nilsson scratched on the > wall: >> Hi All, >> >> I use "PRAGMA table_info" to check my tables at start up and if the >> table columns are the need of updating (adding or removal) I do that. >> >> After a redesign of how the databases are managed this doesn't work >> anymore. Instead of using several database connections, I use one. >> >> The cleaned up the code looks better and is less error prone to select >> the wrong database connection, but it comes with a prize: >> >> "PRAGMA table_info" does not take databases as table names. "test" works >> as an argument, but "main.test" doesn't. > > > No, but following the standard of every other PRAGMA, this does work: > > PRAGMA main.table_info( test ); > > > See the syntax diagrams here: http://sqlite.org/pragma.html > > -j >
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users