How do I check in SQLite whether a table exists?

We can check the table exists or not by execute simple query

private boolean isTableExists(SQLiteDatabase db, String table){
   String sql = "SELECT name FROM sqlite_master WHERE type='table' AND name='"+tableName+"'";
   Cursor mCursor = db.rawQuery(sql, null);
   if (mCursor.getCount() > 0) {
      return true;
   }
   mCursor.close();
   return false;
}

 

Just pass your table name in the above and you will find table exists or not

 

How to convert milli seconds to hours, minutes and seconds in Android? 

How to reduce APK package size?

What are Android Versions available?

What is NetworkOnMainThread Exception?

What is Android Fragments?

How can i comment inside xml file in android studio?

How to get an image resource by it's name in android?

How To Set Text Color Programmatically Android TextView?

How do I check in SQLite whether a table exists?

What is "shared preferences" in Android ?

How to validate email address in Android with Kotlin?

What is ANR? How to avoid and resolve it?

How to get screen size (width,height) in Android?

Key Points to remember while develop the Android Application.  

FCM Not Receiving Notifications in Android - RRutors

Fix Error: Use JsonReader.setLenient(true) for Malformed JSON

How to Exit android app on back pressed?

Fix Duplicate Files in APK Build.gradle Issue - RRutors

Extract Date and Time from Long Type Variable - RRutors

Permission denied for window type 2010 in Marshmallow device

Add Jar/Library Files as Dependency in Android Studio

How to stop EditText  focus at Activity startup in Android?

What happens next when the device switches between portrait and landscape?

What is Application?

How to Get bitmap from drawable: Android

Hide/Disable soft keyboard on Activity launch: Android

Open PDF in Google Drive with Intent in Android - RRutors

Symmetric vs Asymmetric Encryption in Android Server - RRutors

How to install/ uninstall apk by command line ADB

How to convert DP to Pixel and Pixel to Dp?

What is Android?

How do I generate random numbers in Dart?

How do i load image from drawable folder in Jetpack Compose?

How to get complete address from latitude and longitude?

Emulator: emulator: ERROR: Can't find 'Linux version ' string in kernel image file: Andr

What is Intent? What is the difference between an implicit intent and an explicit intent?

What is the difference between match_parent and fill_parent?

Fix Play Store Rejection Due to SMS Permission - RRutors

ERR_ACCESS_DENIED in Android Webview with sdk 30

How to get a contact image using a phone number in android?

Projects By category