/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 votes304 views1 answer
How to insert string variable into sqlite database
SQL
0 vote307 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote318 views1 answer
Add created and updatedAt fields in mysql
SQL
7 votes310 views1 answer
Mysql iif
SQL
1 vote269 views1 answer
Oracle current sequence value
SQL
13 votes307 views2 answers
Sqlite rename table
SQL
0 vote301 views2 answers
Collation in sql
SQL
3 votes293 views1 answer
Select table column in sql
SQL
-2 votes312 views2 answers
Union all in sql
SQL
0 vote254 views0 answer
SQL