Checking a database

You can check a database after upsizing, or after large changes or prolonged editing, or at any time that you suspect problems.

There are several ways to check a database and, if necessary, repair any inefficiencies or errors found. In approximate order of use, you should use these commands:

  • Database Statistics (or Database Design Report)

  • Repair/Compact Database File

  • Schema Integrity Check

  • Link Integrity Check

Except for Database Statistics (or Database Design Report), all these methods work with a database that is not open in iBase Designer.