Ok… I have relegated myself to having to parse Sqlite_master, however using db.Fieldschema is required if sqlite_master indicates the table was created using “CREATE table XYZ AS (select)”, since there is really nothing to parse metadata wise.
The problem is … it seems Db.FieldSchema cannot reference a table in an ATTACHED database???
NEVERMIND… it seems that SQLITE does not insert the ACTUAL SQL used to create the table, but the SQL required to re-create the structure… which is actually kinda nice
So if you say “Create Table XYZ as Select * from ABC” , SQLite Master has “Create Table XYZ (field type,field type,field type)” instead