sqlite3 表构造查询
sqlite3 表结构查询
命令行查看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 [表名]
默认输出所有的表, 建表SQL语句。
推荐方法2