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

5 votes336 views1 answer
Mysql last day of next month
SQL
0 vote315 views1 answer
Joins vs includes
SQL
0 vote301 views1 answer
What is the essence of SQL?
SQL
0 vote310 views1 answer
How to check if there is no database schema
SQL
1 vote328 views1 answer
Tsql find foreign key references
SQL
1 vote319 views1 answer
Sql server get users
SQL
3 votes369 views2 answers
Truncate table
SQL
0 vote302 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote352 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote330 views1 answer
Lost connection to mysql
SQL