/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 vote107 views1 answer
How to see logical reads in sql server
SQL
0 vote66 views1 answer
Copy data from cell to cell mysql
SQL
16 votes118 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
4 votes236 views1 answer
Oracle table statistics
SQL
9 votes111 views4 answers
How to alter table column name in mysql
SQL
1 vote121 views1 answer
Trim leading zeros in sql
SQL
5 votes102 views1 answer
Sql select ciunt
SQL
0 vote114 views1 answer
Print mysql
SQL
0 vote121 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote142 views1 answer
Wordpress make wp user in db
SQL