Why can't I reset the row number count in the android DataBase?

Question

mDb.delete("SQLITE_SEQUENCE", null, null);

It could matter because sometimes we trying to solve a problem not in a right way in the same time not seeing much straightforward and simple solution — sll, Dec 22 '11 at 16:35

score 0 · Answer 1 · edited May 23 '17 at 12:27

0

Try this:

// db = SQLiteDatabase
db.rawQuery("delete from your_table", null);
db.rawQuery("delete from sqlite_sequence where name='your_table'", null);

For detail, please see this.

edited May 23 '17 at 12:27

Community

answered Dec 22 '11 at 17:21

Yaqub Ahmad

1 Answers1