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> select count(*) from sqlite_master where type = 'table';
sqlite-users mailing list
select count() from sqlite_master;
22/12/2011 | 12:51 PM.