· 6 years ago · Jun 29, 2019, 12:30 PM
1public bolean checkAndAddTable(String tableName) {
2 boolean rv = false;
3 SQLiteDatabase = this.getWriteableDatabase();
4 Cursor csr = db.query("sqlite_master",null,"name=? AND type='table'",new String[]{tableName},null,null,null);
5 if (csr.getCount() < 1) {
6 db.execSQL("CREATE TABLE IF NOT EXISTS " + tableName + "(......SQL TO CREATE THE COLUMN DEFINITIONS......)");
7 rv = true;
8 }
9 csr.close();
10 return rv;
11}