"A pragma may have an optional database name before the pragma name. The database name is the name of an ATTACH-ed database or it can be "main" or "temp" for the main and the TEMP databases. If the optional database name is omitted, "main" is assumed. In some pragmas, the database name is meaningless and is simply ignored."
Thus, PRAGMA <database>.user_version; Peter ________________________________ From: Marc L. Allen <mlal...@outsitenetworks.com> To: "sqlite-users@sqlite.org" <sqlite-users@sqlite.org> Sent: Mon, March 12, 2012 10:27:54 AM Subject: [sqlite] PRAGMA user_version of attached database When multiple databases are attached to the main, is there a way to get the user_version of any of the attached DBs? Thanks, Marc -- ****************************************************************** * * * * Marc L. Allen * "... so many things are * * * possible just as long as you * * Outsite Networks, Inc. * don't know they're impossible." * * (757) 853-3000 #215 * * * * * * mlal...@outsitenetworks.com * -- The Phantom Tollbooth * * * * ****************************************************************** _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users