Check if table exists - Android Database

Android examples for Database:Table Exists

  1. HOME
  2. Android
  3. Database
  4. Table Exists

Description

Check if table exists

Demo Code

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DatabaseHelper extends SQLiteOpenHelper {
    private static final String DATABASE_NAME = "record.db";

    private static DatabaseHelper databaseHelper;

    public static DatabaseHelper getInstance(Context context) {
        if (databaseHelper == null)
            databaseHelper = new DatabaseHelper(context);
        return databaseHelper;
    }/*www .j a  v a  2 s.co m*/

    private DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, 1);
    }



    /**
     * Check if the table has exists.
     * 
     * @param db
     *            Instance of SQLiteDatabase
     * @param table
     *            Table Name
     * @see android.database.sqlite.SQLiteDatabase
     * @return
     */
    public boolean tableExists(SQLiteDatabase db, String table) {
        boolean result = false;
        String sql = "select count(*) xcount from sqlite_master where type='table' and name='"
                + table + "'";
        Cursor cursor = db.rawQuery(sql, null);
        cursor.moveToFirst();
        if (cursor.getInt(0) > 0)
            result = true;
        cursor.close();
        return result;
    }
}

Related Tutorials