SQLite Forum

pragma_table_info virtual table, same table names different schemas
Login
Correct syntax is:

~~~~
   SELECT * FROM pragma_table_info('x','db2');
~~~~

The built-in table-valued functions do not belong to any particular datatabase
schema.  So the "db2." prefix does not do anything.  You have to specify the
schema that you want to query as a second parameter.