On Saturday, February 25, 2012 06:12:45 PM Stephan Beal wrote: > On Sat, Feb 25, 2012 at 6:02 PM, inq1ltd <[email protected]> wrote: > > Can someone tell me how to find the names of the tables that exist in a > > database? > > sqlite> create table t1(a); > sqlite> create table t2(a); > sqlite> .h on > sqlite> select * from sqlite_master where type='table'; > type|name|tbl_name|rootpage|sql > table|t1|t1|2|CREATE TABLE t1(a) > table|t2|t2|3|CREATE TABLE t2(a)
I appreciate the help, thanks to all. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
