Click here to Skip to main content
12,952,277 members (42,428 online)
Rate this:
Please Sign up or sign in to vote.
See more:
i have an sqlite table with primarykey,autoincrement Id field.
Once i use the delete command to remove all rows and after this when i try to insert the Id field is not starting from 0, instead its starting from previous max+1 value.
In mysql if we use empty table command and insert again , then we get the Id starting from 1 again.
How can i achieve the same in sqllite.
My real aim is once the table contains 1000 records i want to remove all records and start from id=1 again
Posted 14-Nov-11 0:53am
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

You can drop and recreate the table, or
delete from sqlite_sequence where name='%TABLE NAME%'; 

More info:[^]

Good luck!
Mehdi Gholam 14-Nov-11 7:08am
my 5!
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Use this (where tablename is your table):

DELETE FROM tablename;    
DELETE FROM sqlite_sequence WHERE name = 'tablename';

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,289
CHill60 3,490
Maciej Los 3,103
Jochen Arndt 1,975
ppolymorphe 1,900

Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 14 Nov 2011
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100