Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
The 8700 Table Information page provides information about the number of records in all system and business tables in Business Central, and how much data each table contains.
This information is useful for troubleshooting performance problems because it shows the distribution of data sizes across tables.
To open this page, select the icon, enter Table Information, and then choose the related link.
The following table describes the information provided for each table:
Column | Description |
---|---|
Company Name | The name of the company, if any, that the table belongs to. |
Table Name | The name of the table. |
Table No. | The ID of the table. |
No. of Records | The total number of records stored in the table. |
Record Size | The average record size in KB/record. The value is calculated using the following formula: 1024(Size)/(No. of Records). |
Size (KB) | The total amount of space the table occupies in the database. This value is the sum of the values in the Data Size and Index Size fields. |
Data Size (KB) | How much space the data in the base table occupies in the database. |
Index Size (KB) | How much space the table indexes (keys) on the base table occupy in the database. |
Compression | The type of compression, Row, Page, or None that is applied to the table in the database. To learn more, go to Data compression. |
Note
If you delete data in a table, Business Central starts several processes behind the scenes to make sure that everything is cleaned up in your database. The values on the Table Information page don't update until those processes are complete, which can take a while. The amount of time it takes can vary, depending on the size of your database.
Important
The Table Information page shows data and index (key) sizes for the base table. It doesn't include the sizes for indexed views used to maintain SIFT totals and it doesn't include the data and index sizes used by table extensions. Furthermore, the sum of table sizes doesn't match the total capacity used because it displays the data size, not the actual allocated size. Allocated space is always larger than used space to avoid having to allocate space on every insert, which would limit performance significantly.
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Module
Identify functional table types and characteristics in Dynamics 365 Business Central - Training
Do you want to learn about table types in Business Central? In this module, you'll learn about the different functional table types and their specific characteristics, such as special fields, properties, and linked pages.
Certification
Microsoft Certified: Dynamics 365 Business Central Functional Consultant Associate - Certifications
As a functional consultant, you implement core application setup processes for small and medium businesses. You configure the application in collaboration with the implementation team to provide the business with manageability and ease of use.