/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

12 votes309 views1 answer
How to change the value of a table in sql
SQL
0 vote307 views1 answer
Mysql update sum same table
SQL
0 vote323 views1 answer
MySQL get all previous date record
SQL
3 votes331 views3 answers
Start postgresql ubuntu
SQL
7 votes305 views1 answer
Grant schema permissions postgres
SQL
0 vote308 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
42 votes434 views6 answers
Rename table sql server
SQL
0 vote326 views1 answer
Window function to forward fill
SQL
0 vote356 views1 answer
How to print sql query
SQL
3 votes343 views1 answer
Oracle APEX elapsed time
SQL