The Table Information virtual table contains information about database tables. The Table Information virtual table contains the following fields.
| Field | Description |
|---|---|
|
Company Name |
The name of the company the table belongs to. |
|
Table No. |
The ID number for the table. |
|
Table Name |
The name of the table. |
|
No. of Records |
The number of records in the table. |
|
Record Size |
A value expressing the average size of a record. Calculated as 1024 x Size (KB)/Records. |
|
Size (KB) |
How much space the table occupies in the database (in kilobytes). |
|
Optimization |
A percentage of Size that expresses how much data there is in a table. Some of the remaining size is used for internal administration in the table while the rest is slack-space. Slack-space can be minimized by optimizing the table.1 |
1Not available in the SQL Server Option for Microsoft Dynamics NAV.
 Important |
|---|
|
If a solution uses any of the fields that are not available in the SQL Server Option, it must be modified to run on SQL Server. These columns will not be created on SQL Server. If the program tries to access them, an error message appears. |
To access the Table Information virtual table
-
On the File menu, click Database, and then click Information. The Database Information window appears.
-
Click Tables and the Database Information (Tables) window appears.
| Note |
|---|
|
The illustration shows the Database Information (Tables) table for the SQL Server Option. On Classic Database Server, this window contains an extra field and an extra button. |
