SQLite Forum

pragma_table_info virtual table, same table names different schemas
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.