Reset the row number count in an android DataBase

Question

I need to reset the row number count to 1. How can I do that?

An example for an update query in my code:

public boolean update (long rowId, String title, String body, String reminderDateTime, String loca, String type, String settime, String lat, String llong) {
    ContentValues args = new ContentValues();
    args.put(KEY_TITLE, title);
    args.put(KEY_BODY, body);
    args.put(KEY_DATE_TIME, reminderDateTime);
    args.put(KEY_LOCATION, loca);
    args.put(KEY_TYPE, type);
    args.put(KEY_SETTIME, settime);
    args.put(KEY_LAT, lat);
    args.put(KEY_LONG, llong);


    return mDb.update(DATABASE_TABLE, args, KEY_ROWID + "=" + rowId, null) > 0;

I tried to do that but the eclipse showing me an error:"sqlite_sequence cannot be resolved to a variable"

public void resetAutoNumbering ()
{

     mDb.update(sqlite_sequence, args, KEY_ROWID + "=" + rowId, null);

}

What can I do and how?

Well, that's because `sqlite_sequence` is not a valid name of variable. Think about it, what is so special in `sqlite_sequence` name that it should be resolved without you having any kind of variables with such name in code. — inazaruk, Dec 22 '11 at 08:03

score 2 · Answer 1 · edited May 23 '17 at 10:34

2

Found this as answer for a similar question SQLite Reset Primary Key Field:

delete from your_table; delete from sqlite_sequence where name='your_table';

SQLite Autoincrement

SQLite keeps track of the largest ROWID that a table has ever held using the special SQLITE_SEQUENCE table. The SQLITE_SEQUENCE table is created and initialized automatically whenever a normal table that contains an AUTOINCREMENT column is created. The content of the SQLITE_SEQUENCE table can be modified using ordinary UPDATE, INSERT, and DELETE statements. But making modifications to this table will likely perturb the AUTOINCREMENT key generation algorithm. Make sure you know what you are doing before you undertake such changes.

-axel

edited May 23 '17 at 10:34

Community

1
1

answered Dec 22 '11 at 09:19

AxelTheGerman

986
13
26

I tried to do that but the eclipse showing me an error:"sqlite_sequence cannot be resolved to a variable" – ofeking109 Dec 22 '11 at 10:06
do you get an error from eclipse so you cannot build and run your code or do you get an exception with that error message? could you post the complete error message/exception stacktrace. what sql statement did you use to create your table? the sqlite_sequence table is created automatically when a table with an INTEGER_PRIMARY_KEY column is created. you can use an sqlite viewer (e.g. http://sqlitebrowser.sourceforge.net/ ) to browse your sqlite database (to check whether this table exists or not) – AxelTheGerman Dec 22 '11 at 22:56
@axel's advice worked for me: __database.delete( "sqlite_sequence", "name = '" + TABLE_NAME + "'", null ); – Jon Jun 13 '12 at 01:11

score 0 · Answer 2 · answered Dec 22 '11 at 08:29

0

You use sqlite_sequence in your procedure but before this you used DATABASE_TABLE instead of sqlite_sequence. Change your sqlite_sequence to DATABASE_TABLE.

answered Dec 22 '11 at 08:29

Yury

20,618
7
58
86

I need this table I can't delete it – ofeking109 Dec 22 '11 at 10:07

Reset the row number count in an android DataBase

2 Answers2