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

1 vote285 views1 answer
Mysql sort by date column
SQL
3 votes249 views1 answer
Mysql cli connect with password
SQL
3 votes276 views1 answer
Oracle function
SQL
0 vote190 views1 answer
SQL server select to get sum of hours
SQL
14 votes217 views3 answers
Oracle sql limit results
SQL
0 vote255 views2 answers
Soql last year
SQL
1 vote218 views1 answer
Print all records of table in mysql
SQL
0 vote240 views1 answer
MySql get primary keys of table
SQL
0 vote237 views1 answer
List all permissions on a table in postgres
SQL
5 votes210 views1 answer
Oracle sysdate
SQL