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

 

ERR_ACCESS_DENIED in Android Webview with sdk 30

What are the notifications available in android?

How to Get bitmap from drawable: Android

What is Context?

How to reduce APK package size?

What is the Different Between val and var in Kotlin?

FragmentPagerAdapter deprecated, Since API 27.1.0 FragmentPagerAdapter is deprecated.

What is Android Fragments?

Explain Fragment Life Cycle

Fix Play Store Rejection Due to SMS Permission - RRutors

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

What is Android?

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

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

FCM Not Receiving Notifications in Android - RRutors

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

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

How To Set Text Color Programmatically Android TextView?

How to stop EditText  focus at Activity startup in Android?

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

Open PDF in Google Drive with Intent in Android - RRutors

Extract Date and Time from Long Type Variable - RRutors

What is the difference between match_parent and fill_parent?

Key Points to remember while develop the Android Application.  

How can i comment inside xml file in android studio?

How to validate email address in Android with Kotlin?

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

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

Symmetric vs Asymmetric Encryption in Android Server - RRutors

Fix Duplicate Files in APK Build.gradle Issue - RRutors

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

How do I check in SQLite whether a table exists?

Fix Android Emulator Kill Error When Running Your App

What is NetworkOnMainThread Exception?

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

Android Studio project R can't find

What is ANR? How to avoid and resolve it?

How to Exit android app on back pressed?

How to copy database from assets folder in android using kotlin

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

Projects By category