Database schema integrity check

You can check the integrity of the schema for a database, that is, whether the data held in records follows the rules set up in the database design. The wizard reports any problems found and offers to fix those that it can repair.

About this task

Some repairs may involve additions to the schema or records to make them consistent. For example, the wizard may add indexes or empty fields, or change the size of fields. You can choose to abandon repairs at any point up to final approval, allowing you to assess what the repairs would mean. Eventually, you must repair problems to avoid the possibility of prolonged and greater errors.

Note: You must be logged on to the relevant security file but the database must be closed.

Procedure

Select a database from the list. Click Next. The next page displays a list of all entities and links, together with details of system and user data for each. This is because All is selected, enabling you to see a view of all entities, whether or not they have errors.
Select Errors to see only problems. In a properly functioning database, the errors list should be empty. If there are errors, turn on the checkbox for each error that you want the wizard to repair. Click Next.
Click Finish to perform the listed repairs.
The wizard performs the repairs. When it has finished, click Close.

Note: The database is opened regardless of whether you asked for any repairs.

What to do next

You might want to check the integrity of links. See Checking the database link integrity for details.