Sqlite reset autoincrement

delete from your_table;    
delete from sqlite_sequence where name='your_table';

Source: stackoverflow.com

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

Sqlite reset autoincrement

UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'table_name';

-1

Source: designcise.com

Similar codes

0 vote280 views1 answer
Mssql + bit + in python orm
SQL
0 vote267 views1 answer
Mysql shell set time_zone
SQL
0 vote257 views1 answer
Go install mysql
SQL
0 vote305 views1 answer
What is delimiter in mysql
SQL
0 vote270 views1 answer
Retornar apenas o ano mysql date
SQL
-2 votes276 views1 answer
Group functions in sql
SQL
0 vote289 views1 answer
SQL: calculate hours from two dates
SQL
0 vote274 views1 answer
How to close external sql connection in laravel
SQL
11 votes267 views3 answers
Sqlite3 create table from another table
SQL
0 vote261 views2 answers
How to see table associated with a schema in sql
SQL