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 vote343 views1 answer
Create table Statement Syntax in SQL Server
SQL
4 votes379 views6 answers
List all tables in postgres
SQL
0 vote377 views2 answers
Mysql insert into multiple tables
SQL
0 vote378 views1 answer
Psql check if sql script is valid
SQL
0 vote365 views1 answer
Postgresql find biggest table
SQL
0 vote347 views1 answer
Select insert new table sql server
SQL
0 vote398 views1 answer
Mssql last day of month
SQL
2 votes323 views2 answers
Install sqlalchemy
SQL
11 votes346 views1 answer
Sql query to find duplicates in column
SQL
0 vote359 views1 answer
Copying query result to excel
SQL