This does not seem to work for 3.0.7 If you have a table named "t" in the main database, and you attach a database that has a table named t in it as attachdb, then
pragma attachdb.table_info(t); still seems to give the info for the table t in the main database. Is this a bug or have I got it wrong? On Tue, 2004-10-05 at 14:08, D. Richard Hipp wrote: > Marc Pitoniak wrote: > > > > To get the schema of a table T from A I've tried "PRAGMA table_info('A.T') " > > among other things without any success. > > > > PRAGMA A.table_info(T); -- Edward A. Macnaghten http://www.edlsystems.com