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

Thanks Donald, Ran  "PRAGMA integrity_check;" and it turned "ok" but the select statement using the select return the error message that "...malformed". I am using sqlite3.5.9. Thanks, JP From: "Griggs, Donald" To:

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

Hello Joanne, Regarding: "Is there any command to check if the index or database in good condition." That's why I listed the pragma below in my email of last night and repeat email earlier. You're in luck if only the index is corrupted of course. SAVE a copy of your current database (very