On 13 Mar 2017, at 6:40pm, Marco Silva <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
