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.

Checking the integrity of the schema

Checking the integrity of the links