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

65 votes556 views6 answers
Sql add column to table
SQL
13 votes201 views5 answers
Sql default
SQL
0 vote201 views1 answer
Search starting with mysql
SQL
0 vote190 views1 answer
Show create table in postgresql
SQL
0 vote203 views1 answer
Postgresql inline table
SQL
0 vote199 views1 answer
Select all columns except one sql
SQL
0 vote194 views1 answer
Get the previous column of a table in mysql
SQL
0 vote253 views1 answer
Get initials name in sql
SQL
0 vote143 views1 answer
Get all stored procedures in sql server
SQL
9 votes207 views4 answers
Mysql set id auto increment
SQL