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

3 votes118 views2 answers
Host is not allowed to connect to this mysql server
SQL
3 votes110 views1 answer
Oracle user privileges
SQL
0 vote113 views1 answer
Postgresql using reserved word as column name
SQL
1 vote113 views2 answers
Datetrunc hour snowflake
SQL
0 vote106 views2 answers
Postgresql change user role grant
SQL
0 vote111 views1 answer
Horizontal join sqlite
SQL
1 vote103 views3 answers
Read all columns of a table sql
SQL
42 votes193 views6 answers
Rename table sql server
SQL
3 votes112 views2 answers
Oracle sql drop sequence
SQL
20 votes146 views4 answers
How to find average in sql
SQL