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.
Regards,
Joe
See:
http://www.sqlite.org/sqlite.html
and:
http://www.sqlite.org/faq.html#q7
--
Cheers -- Tim
Somthing like
sqlite3 sqlite.file
sqlite> select count(*) from sqlite_master where type = 'table';
/Roger
sqlite-users mailing list
sqlite-users*******:8080/cgi-bin/mailman/listinfo/sqlite-users
select count() from sqlite_master;
No??
...where type='table';
Cheers,
Mohit.
22/12/2011 | 12:51 PM.
Related Topics
Post a Comment
