/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

14 votes146 views2 answers
Oracle add column with default value
SQL
0 vote165 views1 answer
Print intervals of 15 minutes in sql query
SQL
0 vote222 views1 answer
Trigger
SQL
0 vote206 views1 answer
Mysql failed to login as root@localhost
SQL
0 vote162 views2 answers
Starts and end with vowel sql
SQL
0 vote155 views1 answer
Drop column from local database postgres pgadmin
SQL
25 votes168 views6 answers
Import database mysql command line
SQL
0 vote137 views1 answer
Opensuse stop MySQL
SQL
0 vote161 views1 answer
How to inner join 4 tables in sql
SQL
2 votes145 views1 answer
Set boolean flasksql
SQL