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

 

Decompile APK Files: How to Get Source Code - RRutors Guide

Fix Duplicate Files in APK Build.gradle Issue - RRutors

Symmetric vs Asymmetric Encryption in Android Server - RRutors

How to Get bitmap from drawable: Android

Fix Behavior Subclass BottomSheetBehavior Exception - RRutors

Hide/Disable soft keyboard on Activity launch: Android

How to copy database from assets folder in android using kotlin

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

How to stop EditText  focus at Activity startup in Android?

Add Jar/Library Files as Dependency in Android Studio

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

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

How to Generate signed apk with android studio

Explain Fragment Life Cycle

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

What is the difference between match_parent and fill_parent?

What is Context?

ERR_ACCESS_DENIED in Android Webview with sdk 30

How to start a new activity on button click

How can i comment inside xml file in android studio?

What is ANR in android?

Permission denied for window type 2010 in Marshmallow device

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

Key Points to remember while develop the Android Application.  

How do I check in SQLite whether a table exists?

How to get complete address from latitude and longitude?

What is "shared preferences" in Android ?

What is the Different Between val and var in Kotlin?

How to reduce APK package size?

What is Android?

What is Android Fragments?

FCM Not Receiving Notifications in Android - RRutors

What is ANR? How to avoid and resolve it?

How to find Android Device UDID or unique ID?

INSTALL_FAILED_INVALID_APK: Split lib_slice_9_apk was defined multiple times. It is possible that th

What are Android Versions available?

How to save activity State in Android?

What is NetworkOnMainThread Exception?

How to check Android version?

How to avoid multiple button click at same time in android?

Projects By category