/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

2 votes129 views1 answer
Sql update from different table
SQL
10 votes140 views2 answers
Sql pagination offset
SQL
1 vote154 views1 answer
Oracle plan hash value
SQL
1 vote136 views1 answer
Tsql get beginning of year
SQL
3 votes172 views2 answers
@sqlresultsetmapping
SQL
2 votes119 views1 answer
Codeigniter print last sql query
SQL
0 vote167 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote144 views1 answer
Shell script to log mysql cpu usage
SQL
15 votes161 views4 answers
Sql update from select
SQL
2 votes128 views1 answer
Sql create database
SQL