/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 vote338 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
0 vote344 views1 answer
Compare subqueries oracle
SQL
0 vote303 views1 answer
Mysql group rows with same value
SQL
0 vote373 views1 answer
How to use sqlcommand
SQL
1 vote362 views3 answers
How to pass password to mysql command line
SQL
4 votes340 views1 answer
Oracle session date format
SQL
0 vote327 views1 answer
Mysql date time string format python
SQL
0 vote310 views1 answer
Get duplicate entry sql
SQL
0 vote347 views1 answer
Separator mysql
SQL
6 votes333 views1 answer
Phpmyadmin password root
SQL