/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

0 vote184 views1 answer
Date datatype in livesql
SQL
0 vote183 views1 answer
Psql list rules
SQL
0 vote184 views1 answer
Sql select most frequent value in group
SQL
1 vote206 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote236 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
2 votes189 views1 answer
Change primary key sql
SQL
20 votes233 views4 answers
How to find average in sql
SQL
0 vote186 views1 answer
Sql server convert date to weekday
SQL
0 vote188 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
1 vote202 views1 answer
Oracle nvl2
SQL