sqlite学习

列出数据库中所有表

SELECT name FROM sqlite_master WHERE type='table' order by name。

或.schema tabl1;

复制表结构

create table name2 as select * from name1 where 1=2;