/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 vote194 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote168 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
6 votes206 views2 answers
Subtr Oracle ?
SQL
0 vote176 views1 answer
Dnsmasq.conf location macos
SQL
0 vote187 views2 answers
How to delete the rows with null values in mysql
SQL
1 vote203 views3 answers
How to pass password to mysql command line
SQL
0 vote254 views1 answer
Play framework connection via windows sql server
SQL
0 vote194 views2 answers
Reseed sql identity
SQL
3 votes175 views1 answer
V$session not found in oracle
SQL
1 vote196 views1 answer
Convert varchar to int in sqlite
SQL