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 vote204 views1 answer
Mysql command line top 10
SQL
3 votes203 views1 answer
Apex set debug level
SQL
2 votes183 views2 answers
Mysql on duplicate key update get value from values
SQL
32 votes172 views6 answers
Sql count where
SQL
5 votes189 views2 answers
Postgresql add not null constraint
SQL
0 vote169 views1 answer
Dbms_output sql developer
SQL
0 vote163 views1 answer
How to use group_concat in sql server
SQL
8 votes168 views2 answers
Between operator
SQL
0 vote168 views1 answer
Eliminar ultimo carcacter mysql
SQL
0 vote158 views1 answer
Oracle free up space in tablespace
SQL