Re: [sqlite] Arranging of ids in Sqlite3

; 15 > > However, it is not a good idea to change a primary key, especially if > there are other data in other tables depending on it. > > Martin > > Nikhil Kansal wrote: > > Hi, > > > > I am using id as a integer primary key... > > like > > CREATE

[sqlite] Arranging of ids in Sqlite3

Hi, I am using id as a integer primary key... like CREATE TABLE history( id INTEGER PRIMARY KEY, filename varchar NOT NULL) now if i delete a entry from this table and add a entry again then a id will be left blank in between. Can we rearrange this ID. Regards, Nikhil ___