Microsoft Dynamics NAV allows you to test the tables in the database. From the Test Tables window, you can enable the same tests, except the space allocation test, that you can from the File menu. If you choose to test only one table and select, for example, Test field relationships between tables, then the relationships between the selected table and the tables that are related to it will be tested.

To test a table

  1. In the development environment, on the File menu, choose Database, and then choose Information. The Database Information window opens.

  2. Choose the Tables button, and the Database Information (Tables) window opens.

  3. Select the tables that you want to test. If you do not select any tables, then the test will be run on all the tables.

  4. Choose the Test button, and the Test window opens.

  5. Select the tests that you want to perform. Some of the tests must be combined. For more information about the features that are tested, see How to: Test Databases.

  6. Choose the Options tab to specify how the output from the database test is managed. The output from the test consists of the errors messages that are generated. These can be handled as follows:

    • Screen: The error messages are displayed on the screen. Each time an error message is displayed you must choose the OK button before the test continues. This can be very troublesome if the test generates many messages.
    • Event Log: The error messages are written in the operating system’s event log. For more information about the event log, see the operating system’s documentation.
    • File: The error messages are written to a text file. Use the AssistEdit button to select the name and location of the text file.

    If you select Event Log or File, then the test is not interrupted and will not take as long as if you select Screen. You can then review any error messages that were generated and repair the things that caused them.

  7. Choose the OK button to perform the test.

    After you start the test, a window opens that contains information about the test status.

See Also

Tasks

How to: Test Databases

Reference

Test Tables

Concepts

Tables