Re: [sqlite] listing tables in a database

[Adam DeVita]

SELECT name, sql FROM sqlite_master WHERE type='table'

On Thu, Jun 18, 2009 at 12:47 PM, Gary Johnson wrote:

> I'm looking for a way to programmatically get a list of all tables in
> an SQLite database -- effectively emulating the .tables command but
> using the C API calls.  I've been through the documentation but
> couldn't find anything.  I'm hoping someone on his list might be able
> to point me in the right direction.
>
> Thanks!
> Gary
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
VerifEye Technologies Inc.
905-948-0015x245
7100 Warden Ave, Unit 3
Markham ON, L3R 8B5
Canada
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] listing tables in a database

[Gary Johnson]

I'm looking for a way to programmatically get a list of all tables in  
an SQLite database -- effectively emulating the .tables command but  
using the C API calls.  I've been through the documentation but  
couldn't find anything.  I'm hoping someone on his list might be able  
to point me in the right direction.

Thanks!
Gary
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users