Table 8700 "Table Information Cache"
System Application · System.DataAdministration
Across versions
- BC23-26present
- BC273 fields changed
- BC28-30unchanged
Neighbourhood 1 connected objects and pages
System Application · System.DataAdministration · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Access | Internal |
| DataClassification | SystemMetadata |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Company Name | Text[30] | Specifies the name of the company the table belongs to. via Page 8701 “Table Information Cache Part” | |
| 2 | Table No. | Integer | Specifies the ID of the table. via Page 8701 “Table Information Cache Part” | |
| 3 | Table Name | Text[30] | Specifies the name of the table. via Page 8701 “Table Information Cache Part” | |
| 4 | No. of Records | Integer | Specifies the total number of records stored in the table. via Page 8701 “Table Information Cache Part” | |
| 5 | Record Size Δ BC27 | Decimal | Specifies the average record size (in bytes). via Page 8701 “Table Information Cache Part” | |
| 6 | Size (KB) | Integer | Specifies the total amount of space the table occupies in the database (in kilobytes). via Page 8701 “Table Information Cache Part” | |
| 7 | Compression | Option | Specifies the type of compression that is applied to the table in the database. via Page 8701 “Table Information Cache Part” | |
| 8 | Data Size (KB) | Integer | Specifies how much space the table data occupies in the database (in kilobytes). via Page 8701 “Table Information Cache Part” | |
| 9 | Index Size (KB) | Integer | Specifies how much space the table indexes (keys) occupy in the database (in kilobytes). via Page 8701 “Table Information Cache Part” | |
| 8700 | Last Period Data Size (KB) Δ BC27 | Integer | Specifies how much space the table occupied in the database 30 days ago (in kilobytes). via Page 8701 “Table Information Cache Part” | |
| 8702 | Growth % Δ BC27 | Decimal | Specifies how much the table size grew in 30 days (in percent). via Page 8701 “Table Information Cache Part” | |
| 8701 | Last Period No. of Records | Integer | Specifies the number of records in the table 30 days ago. via Page 8701 “Table Information Cache Part” |
Keys
- pk: Company Name, Table No.
- sort: Data Size (KB)
Pages and codeunits on this table
- Page 8701 “Table Information Cache Part” (source table)
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Table Information Cache"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.