How to fix index corruption in embedded databases
An an example, let's suppose an index in ORDITEM is corrupted.
Here is how to fix that table.
1. Using the ODBC utility, first export the table contents.
Select ORDITEM table and tap Table Export button:
Tapping export will dump this table into ORDITEM.sql as SQL create statements, one for each line of the table:
when it's done, you'll see this:
