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) -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
