/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 vote106 views1 answer
Postgresql can you have null foreign key
SQL
0 vote105 views1 answer
Sqlalchemy query return only n results
SQL
0 vote120 views1 answer
Arithmetic expression in sql
SQL
2 votes102 views1 answer
Postgresql transaction
SQL
7 votes120 views1 answer
Show line number in sql server
SQL
9 votes102 views6 answers
Sql insert into
SQL
1 vote116 views1 answer
Blob datatype in mysql
SQL
0 vote96 views1 answer
Mysql table variables
SQL
8 votes104 views1 answer
Oracle create datafile
SQL
0 vote112 views2 answers
Get value from a table an insert it with other values in another table sql
SQL