On 13 Mar 2017, at 6:40pm, Marco Silva <marco.prado...@gmail.com> wrote:
> Does anyone knows a Common Table Expression (CTE) to be used with the > sqlite_master table so we can count for each table how many rows it > has. The way SQLite stores its data is not helpful to counting the rows. The number of rows isn’t stored anywhere and to find out the number of rows in a table SQLite has to iterate through them all. The fastest way to find the number of rows in a table is SELECT COUNT(*) FROM MyTable and I’m afraid there is no simple command which does this for more than one table. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users