tableAdministration & Setupofficial - Microsoftderived - from the source, no model text

Table 8700 "Table Information Cache"

System Application · System.DataAdministration

Across versions

  1. BC23-26present
  2. BC273 fields changed
  3. BC28-30unchanged

Neighbourhood 1 connected objects and pages

Page 8701 "Table Information Cache Part" (pages and codeunits on it)Table Information Cache Part

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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

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.

Evidence 1 sources