命令行查看sqlite3表结构的命令
sqlite3 xxxxx.db
sqlite version 3.7.15.1 2012-12-19 20:39:10
Enter ".help" for instructions
Enter sql statements terminated with a ";"
sqlite>
sqlite version 3.7.15.1 2012-12-19 20:39:10
Enter ".help" for instructions
Enter sql statements terminated with a ";"
sqlite>
方法1
sqlite>. select * from sqlite_master where type="table";
方法2
sqlite>.schema [表名]
推荐方法2
原文链接:https://www.f2er.com/sqlite/201555.html