how find longest memo field in table of database?
can single sql query?
thanks downvotes, guys. can presume didn't read question & think asking how find longest memo in given table, rather longest memo in entire database, not quite simple (which why ask).
it doesn't take long post reason downvoting - might educate me , wouldn't have downvote often.
it not possible have dynamic table names in queries.
you have list of tables (with select name sqlite_master type = 'table'
or that) , execute 1 query each table (and each column).
(sqlite has no programming constructs; have in language accessing database.)