On 4/10/2013 11:47 AM, Bheemrao, Veeresh wrote:
I would like to know is there any way to get row count for all the tables in a
database using single Execute command?
select (select count(*) from table1), (select count(*) from table2), ...;
There is no system table that stores row counts for other tables, if
that's what you are asking. The only way to know how many rows a table
contains is to count them.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
