如果只想查看具体一张表的表结构,比如查看emperors表,命令为:
select * from sqlite_master where type="table" and name="emperors";
另外,也可以这样:
sqlite> .schema emperors
select * from sqlite_master where type="table" and name="emperors";
另外,也可以这样:
sqlite> .schema emperors