/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

1 vote354 views2 answers
Sql drop multiple columns if exists
SQL
0 vote367 views1 answer
Consulta alias con inner join
SQL
0 vote347 views1 answer
Oracle sql drop table
SQL
0 vote352 views1 answer
Mysql utc timestamp
SQL
-1 vote342 views1 answer
Mysql delete duplicate rows except one
SQL
0 vote333 views1 answer
Go install mysql
SQL
0 vote348 views1 answer
Except in sql
SQL
-1 vote378 views3 answers
Error: mysql shutdown unexpectedly.
SQL
1 vote348 views1 answer
Sample clause in sql
SQL
0 vote373 views1 answer
How to remove quotes from a string in ssis load file
SQL