Android Sqlite数据库中判断某个表是不是存在的SQL语句

Android Sqlite数据库中判断某个表是否存在的SQL语句

select count(*) as isExsit from sqlite_master where type="table" and name=表名;

 

例如:

 

select count(*) as isExsit from sqlite_master where type="table" and name="categories";

 


Android  Sqlite数据库中判断某个表是不是存在的SQL语句