-- 查看所有表select name from sqlite_master wheretype='table';-- 查看所有索引select name from sqlite_master wheretype='index';-- 查看所有视图select name from sqlite_master where
查看当前数据库对象信息-- 查看所有表select name from sqlite_master where type = 'table';-- 查看所有索引select name from sqlite_master where type = 'index';-- 查看所有视图select name from sqlite_master where type = 'view';查看表结构命令行执行.schema databaseitem使用查询语句select * from s