Reference database name in sqlite studio

Question

In Sqlite studio, I usually select the database name from the dropdown before executing a query. However if I want to specify the database name in the SQL itself, something like

  Select * from C:\Folder\DbList\Test.Db \<tableName>.

Answer 1

Having several databases open at sametime in SQLite Studio. You can access to all of them from the same SQL query window independentely of the value for db in the dropdown menu that you said.

example of selects from 2 databases

SELECT  title, body
   FROM myDB_1.Notas
   WHERE ROWID< 20
UNION
SELECT  title, content
    FROM my_DB2.texto

Note that score symbol "-" in db name produces errors, so replace it by underscore