/SQL/How to reset autoincrement in sqlite java

How to reset autoincrement in sqlite java

db.delete("SQLITE_SEQUENCE","NAME = ?",new String[]{TABLE_NAME});
/*
when deleting or adding rows with AUTOINCREMENT used to reset counter 
to biggest primary key in table Author Akhilesh Dhar Dubey
*/

-1

Source: stackoverflow.com

Similar codes

5 votes269 views1 answer
Oracle asynchronous update
SQL
2 votes309 views2 answers
Null column to 0 in mysql
SQL
1 vote255 views1 answer
How to select random rows from table
SQL
3 votes270 views1 answer
Postgresql db owner change
SQL
2 votes279 views1 answer
Set auto increment from 1
SQL
0 vote261 views2 answers
Sql update multiple tables
SQL
0 vote249 views2 answers
Mysql slave status
SQL
0 vote246 views1 answer
Ms Sql set us timezone
SQL
0 vote291 views1 answer
Change date format in oracle query
SQL
0 vote295 views1 answer
How to move a columns location in mysql
SQL