On 9/26/06, Mark Pirogovsky <[EMAIL PROTECTED]> wrote:
One can query the sqlite_master table to find out all the available
tables and views.
However if you open (via ATTACH [DATABASE] sql command) more then one
database files in the sessions, the sqlite_master only shows the tables
in the latest opened file.
Is there a way to see all the tables in all of the database files opened
for the session ?
Try this:
ATTACH "atch.db" AS atch;
SELECT * FROM atch.sqlite_master;
--
Nemanja Corlija <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------