转自:http://blog.sina.com.cn/s/blog_77eab95f0101t8qp.html
查询table,type 段是'table',name段是table的名字, so:
select name from sqlite_master where type='table' order by name;
查询indices,type段是'index', name 是index的名字,tbl_name是index所拥有的table的名字
通过以下语句可查询出某个表的所有字段信息
PRAGMA table_info([tablename])
如果在程序中你可以通过 sqlite_master
sqlite> select type, name, tbl_name from sqlite_master order by type;
type|name|tbl_name
index|sqlite_autoindex_t1_1|t1
index|sqlite_autoindex_numtable_1|numtable
table|t1|t1
table|numtable|numtable
table|test|test
table|sqlite_stat1|sqlite_stat1
table|MailLabel|MailLabel
sqlite>
sqlite_master
SQLite Master Table Schema
-----------------------------------------------------------------
Name
-----------------------------------------------------------------
type
name
tbl_name
rootpage
sql