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 ?


-- Mark Pirogovsky

"Computers made it possible to make millions mistakes a second"
"Ask no questions and hear no lies"

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to