sql - How to find the longest memo field in any table of my database? -


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.)