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
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
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
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:
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
5 matches
Mail list logo