Re: [sqlite] command line to get number of tables in sqlite

2011-12-21 Thread Mohit Sindhwani
On 22/12/2011 7:25 AM, Matt Young wrote: select count() from sqlite_master; No?? ...where type='table'; Cheers, Mohit. 22/12/2011 | 12:51 PM. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] command line to get number of tables in sqlite

2011-12-21 Thread Matt Young
select count() from sqlite_master; No?? On Wed, Dec 21, 2011 at 10:32 AM, 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

Re: [sqlite] command line to get number of tables in sqlite

2011-12-21 Thread Roger Andersson
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

Re: [sqlite] command line to get number of tables in sqlite

2011-12-21 Thread Tim Streater
On 21 Dec 2011 at 18:32, smallboat wrote: > 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. See: http://www.sqlite.org/sqlite.html and:

[sqlite] command line to get number of tables in sqlite

2011-12-21 Thread smallboat
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 ___ sqlite-users mailing list sqlite-users@sqlite.org