Is there a function that does what I have described?
> Defragging the database just removes empty pages making the database > file smaller. It doesn't actually touch any data. > > Have a look here: > http://www.sqlite.org/lang.html#vacuum > > AJ > > On Tue, 28 Dec 2004 17:30:10 +0100, D.W. <[EMAIL PROTECTED]> wrote: > > I have deleted some objects in my database. Now I have objects at id > > (INTEGER PRIMARY KEY) =1,3,4,5,7,8,9,16,17,20.... . > > id=2,6,10,.. are empty. I want to defrag the database so that I have objects > > continuously at id=1,2,3,4,5,6,7,... > > Is the vacuum function not the right function? > > Daniel >
