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

 

Add Jar/Library Files as Dependency in Android Studio

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

How to check Android version?

How to Exit android app on back pressed?

How to validate email address in Android with Kotlin?

Fix Android Emulator Kill Error When Running Your App

What is ANR? How to avoid and resolve it?

What is Android?

Explain Fragment Life Cycle

What is "shared preferences" in Android ?

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

What is Application?

Fix Play Store Rejection Due to SMS Permission - RRutors

What are the notifications available in android?

ERR_ACCESS_DENIED in Android Webview with sdk 30

What are Android Versions available?

Symmetric vs Asymmetric Encryption in Android Server - RRutors

How can i comment inside xml file in android studio?

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

What is NetworkOnMainThread Exception?

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

How do I generate random numbers in Dart?

What is the Different Between val and var in Kotlin?

How do I check in SQLite whether a table exists?

FragmentPagerAdapter deprecated, Since API 27.1.0 FragmentPagerAdapter is deprecated.

How to Generate signed apk with android studio

Set Activity to Fullscreen Mode in Android - RRutors

How to convert DP to Pixel and Pixel to Dp?

How to reduce APK package size?

How to find Android Device UDID or unique ID?

Permission denied for window type 2010 in Marshmallow device

What is Android Fragments?

Invoke-customs are only supported starting with android 0 --min-api 26

How To Set Text Color Programmatically Android TextView?

Check List for Generate Signed APK Android

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

Hide/Disable soft keyboard on Activity launch: Android

Fix Behavior Subclass BottomSheetBehavior Exception - RRutors

How to Use Deprecated Handler() in Android - RRutors Guide

How to stop EditText  focus at Activity startup in Android?

Projects By category