Somthing like sqlite3 sqlite.file sqlite> select count(*) from sqlite_master where type = 'table';
/Roger On 12/21/11 19:32, smallboat wrote:
Hello, I have a sqlite file. I would like to open it and know how many tables in it. What is the command line to open a sqlite file and get to know how many tables in it? Thanks.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users