sqlite3 查找 所有表名字

http://stackoverflow.com/questions/82875/how-do-i-list-the-tables-in-a-sqlite-database-file

it appears you need to go through the *sqlite_master* table,like this:

SELECT * FROM dbname.sqlite_master WHERE type='table';

如果在db中进行操作，可以把“dbname.”去掉，就ok了。

And then manually go through each table with a SELECT or similar to look at the rows.

The .DUMP and .SCHEMA commands doesn't appear to see the database at all.

找了一下午，有留言说awesome。。。也代表我测试成功一刻的心情。。。感谢stackoverflow，感谢问这个问题和答这个问题的大牛小牛们

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!