On 5 Mar 2011, at 8:40pm, Kai Peters wrote: > Is it possible to obtain select result set containing the table names of all > user tables in a > database
Take a look at the results of SELECT * FROM sqlite_master and work out your own way of listing the tables. > along with their record counts? Not directly, the fastest way is to do for each table SELECT count(*) FROM tableName Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
