Re: [sqlite] How to check the healthy of database and the indexes of the tables

Thanks, I used sqlite 3.5.9 but when I ran PRAGMA integrity_check; it returns OK but one of the index has problem. Thanks, JP   From: Kees Nuyt To: sqlite-users@sqlite.org Sent: Tuesday, May 5, 2009 1:30:58 PM Subject: Re: [sqlite] How to

Re: [sqlite] How to check the healthy of database and the indexes of the tables

On Tue, 5 May 2009 13:02:13 -0700 (PDT), Joanne Pham wrote: >Hi All, > I had the database and one of the index is >not good condition. Every time I use the >index by select ... group by .. the result >only return few rows and the message print >out that "database disk

[sqlite] How to check the healthy of database and the indexes of the tables

Hi All, I had the database and one of the index is not good condition. Every time I use the index by select ... group by .. the result only return few rows and the message print  out that "database disk image is malformed". Is there any command to check if the index or database in good