How can I reset autoincrement using SqLite in Android?

Question

I have to reset the autoincrement in my database. I can't do the "drop table" and recreate the table.

is there anyway to reset the autoincrement?

Maybe explain why you believe resetting auto increment in your scenario is required. This breaks database integrity, I would think, so there is probably an alternative solution you should consider. — Colin M., May 07 '14 at 17:53
Is this the one you are searching for ? http://stackoverflow.com/questions/5586269/how-can-i-reset-a-autoincrement-sequence-number-in-sqlite — Nidheesh, May 07 '14 at 18:04
possible duplicate of [Resetting Autoincrement in Android SQLite](http://stackoverflow.com/questions/9759502/resetting-autoincrement-in-android-sqlite) — CL., May 07 '14 at 18:05

score 2 · Accepted Answer · answered May 08 '14 at 12:39

2

It is possible using this Query

db.execSQL("DELETE FROM SQLITE_SEQUENCE WHERE NAME = '" + name_of_the_table + "'");

answered May 08 '14 at 12:39

Sainath Patwary karnate

3,165
1
16
18

score 0 · Answer 2 · answered Jul 12 '19 at 17:19

I use this one, maybe it will help

    public boolean deleteAll() {

    SQLiteDatabase db = this.getReadableDatabase();
    db.delete("SQLITE_SEQUENCE","NAME=?",new String[]{TABLE_NAME});
    int affectedRows = db.delete(this.TABLE_NAME, null, null);
    return affectedRows > 1;
    }

How can I reset autoincrement using SqLite in Android?

2 Answers2