1,查询表名集合
SELECT name FROM sqlite_master
WHERE type='table'
ORDER BY name;
2,编程语言遍历删除
public static bool deleteAllData()
{
bool res = false;
SQLiteConnection conn = null;
DbTransaction trans = null;
try
{
string sql = "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name";
DataSet ds = new DataSet();
ds = CommonBll.getDataSetBySql(sql, Constant.SQLITE_FLAG);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
using (conn = SqliteHelper.GetConnection())
{
var cmd = new SQLiteCommand(conn);
//开始事务
trans =