@Kulwinder Singh i implemented that but getting

java.lang.IllegalStateException: Cannot perform this operation because there is no current transaction.

It run for the first time then crash for second time

fun clearAndResetAllTables(): Boolean {
        if (db== null) return false

        // reset all auto-incrementalValues
        val query = SimpleSQLiteQuery("DELETE FROM sqlite_sequence")

        db!!.beginTransaction()
        return try {
            db!!.clearAllTables()
            db!!.query(query)
            db!!.setTransactionSuccessful()
            true
        } catch (e: Exception){
            false
        } finally {
            db!!.endTransaction()
        }
    }

Terrible code style, do not copy this in your project. all those

!!

replace first string to val db = db ?: return

yes, exactly.

I do end the transaction …. but am getting this

Cannot perform this operation because there is no current transaction.

I do end the transaction

This error about begin transaction, not about end transaction Check that you begin transaction in all cases and that you don’t call this method concurrently