SELECT name, sql FROM sqlite_master WHERE type='table' On Thu, Jun 18, 2009 at 12:47 PM, Gary Johnson <gary.john...@covad.net>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