Shows all tables in the database. You can use this information to check how effectively the database is being used.

To open this window, on the File menu, choose Database, choose Information, and then in the Database Information window, choose the Tables button.

Fields

Field Description

Company Name

The name of the company to which the table on the line belongs.

Table No.

The number of the table. Each table has a unique number.

Table Name

The name of the table. This is the name that is displayed when you choose the Table button in Object Designer.

No. of Records

The number of records (entries) in the table. By keeping track of how many new records have been added during a certain period, you can estimate the number of records that you can expect in the next period. You can use this value with the value in the Record Size field to estimate whether you have sufficient space in the database to meet your requirements.

Record Size

The average number of bytes per record in the table.

Size(KB)

The total size of the table, in kilobytes.

Buttons

Button Function

Optimize

  • For each Microsoft Dynamics NAV table, rebuilds the SQL Server indexes, other than the primary key, to optimize their layout and usage.
  • For each SumIndexField Technology (SIFT) structure, removes any entries that contain zero values in all numeric fields. The removal of these redundant entries frees space and provides more efficient updating and summing of SIFT information.

Test

Opens the Test Tables window and tests the selected tables. If you do not select any tables, then the test is run on all tables.

In the Test Tables window, you can enable the same tests, except the space allocation test, that you can from the Test Database window. For more information about the features that are tested, see How to: Test Databases.

If you select only one table to test and select Test field relationships between tables, then the relationships between the selected table and the related tables are tested.

Key Groups

Opens the Database Key Groups window so that you can enable or disable key groups.

See Also