Good Afternoon,
I have been having an issue trying to resolve an error all afternoon, and hope that you might be able to help.
I am trying to execute the follow SQL "
SELECT m.name as tableName,
p.name as columnName
FROM sqlite_master m
left outer join pragma_table_info((m.name)) p
on m.name <> p.name
where columnName = 'UploadedFlag'
order by tableName, columnName
" That returns a list of the tables that Contain the 'UploadedFlag' Column. I have testing the SQL on both HeidiSQL and SQLite Expert Personal applications and run and return