"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

Reply via email to